Archives of the TeradataForum

Message Posted: Fri, 20 May 2005 @ 12:45:56 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Re: COMPRESSing spaces

From:		Dieter Noeth

Anomy Anom wrote:

Is there any difference between

          NAME CHAR(10)  COMPRESS '          '

and

          NAME CHAR(10)  COMPRESS ' '

No.

Each compress string is automatically padded with blanks:

     create table anomyanom(
        pi int,
        NAME1 CHAR(10)  COMPRESS '         '
        ,NAME2 CHAR(10)  COMPRESS ' '
     );

       *** Table has been created.
       *** Total elapsed time was 1 second.

     show table anomyanom;

       *** Text of DDL statement returned.
       *** Total elapsed time was 1 second.

     ------------------------------------------------------------
     CREATE SET TABLE TERADATA_EDUCATION.anomyanom ,NO FALLBACK ,
           NO BEFORE JOURNAL,
           NO AFTER JOURNAL,
           CHECKSUM = DEFAULT
           (
            pi INTEGER,
            NAME1 CHAR(10) CHARACTER SET LATIN NOT
              CASESPECIFIC COMPRESS '          ',
            NAME2 CHAR(10) CHARACTER SET LATIN NOT
              CASESPECIFIC COMPRESS '          ')

     PRIMARY INDEX ( pi );

Dieter


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Attachments

Library

Quick Reference