Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 02 Apr 2009 @ 11:19:39 GMT


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


Subj:   Re: Comparison of UNICODE and LATIN column in SELECT
 
From:   David Clough

Yes, we noticed that some time ago with regards to joining LATIN to UNICODE.

Basically, don't do it.

Solutions you might want to consider are :-

i) copy one of the tables into the other character set (but that may be a lot of data)

ii) adding another column onto the table with the other character set (but then you may have problems with Primary Index choices, and maybe column naming)

iii) change everything to Unicode (takes double the space)

iv) come up with an even better solution ... in which, please let us know.


Hope that helps


Regards

David Clough
Database Developer
Database Design Group



     
  <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