Archives of the TeradataForum

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

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

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>>