Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 26 Jun 2006 @ 17:36:54 GMT


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


Subj:   Re: Loading Chinese Characters into the database
 
From:   Takahashi, Takashi

First of all, when loading these Chinese characters in UTF8, the session character set should be UTF8 and the column character set should be UNICODE. After loading data into the Unicode column, then you can verify the internal Unicode (i.e. UTF16) value by:

     Select CHAR2HEXINT(your_column_name) from your_table_name;

For Chinese characters '??????', the UTF16 hex value should be: 635F,76CA,8868.

I believe that your data is Simplified Chinese, so with SQLA 7.1, you can use either UTF8 or SCHGB2312_1T0 session character set. However, the SCHGB2312_1T0 session character set has a limitation and does not support all 24,000 Chinese characters. So you might want to use one the site- defined session character sets for Simplified Chinese, or use UTF8. The UTF8 session should support all Chinese characters you have.

BTEQ does not support to enter/display UTF8 characters even under the UTF8 session character set.

Hope this would help.



     
  <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