Archives of the TeradataForum

Message Posted: Fri, 23 Jun 2006 @ 14:58:30 GMT

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

You did not say what version of Queryman you were using.

I ran the following tests using a UTF8 session with SQL Assistant 7.1. (I set the input buffer size to 50 - the default of 30 is too small.)

     CREATE SET TABLE dbcmngr.ChineseTest ,FALLBACK
       (
        Idx    SMALLINT,
        Note   VARCHAR(50) CHARACTER SET UNICODE)
     UNIQUE PRIMARY INDEX ( Idx );

     INSERT INTO dbcmngr.ChineseTest VALUES (?, ?)

I imported a UTF8 data file created from the data you provided in your email.

     SELECT * FROM dbcmngr.ChineseTest ORDER BY 1

The displayed results exactly match the import data file.

Note that I am not using any special Chinese character sets. I am storing the data in a Unicode column in the table.

Mike Dempsey
Teradata Client Tools

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