Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 28 Apr 2004 @ 09:11:43 GMT


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


Subj:   Re: Column Compress Question
 
From:   Dieter Noeth

Chris Craig wrote

  One other thing to be aware of. If you have CASESPECIFIC specified on the column, then you must specify your charater string with the same mix of upper and lower characters.  


  So, to compress 'ABCdef' you should specify  


  COMPRESS 'ABCdef'  


  If NOT CASESPECIFIC then any combination works.  



No, you still have to specify the right mixture of uppercase/lowercase characters, because otherwise any combination would be stored as 'ABCdef'. A DBMS is supposed to store the string you submitted and not a different one
;-)


Dieter



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016