Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 19 Dec 2006 @ 16:59:26 GMT


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


Subj:   Re: Looking for bad data
 
From:   Anomy Anom

<-- Anonymously Posted: Wednesday, January 21, 2004 07:04 -->

Character string comparisons, equality as well as ordering, depend on the SESSION COLLATION setting. CASESPECIFIC or NOT CASESPECIFIC (case- blind) are actually modifiers to COLLATION not CHARACTER SET. Use SHOW SESSION to see what collation is in effect. See the chapter on Collation Sequences in the International Character Set Support manual for more detail.

And the actual data values stored in the UNICODE column will depend on SESSION CHARACTERSET of the session doing the INSERT VALUES so you have to be careful there as well.



     
  <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: 15 Jun 2023