Archives of the TeradataForum

Message Posted: Thu, 22 Jun 2006 @ 14:54:39 GMT

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

You should be able to load Unicode data with SQL Assistant.

The following rules will apply:

1 - You must use a UTF8 or UTF16 session character set in the ODBC DSN.

2 - The data must be in a unicode file (UTF8 or UCS2/UTF16)

3 - The Import file must include the 2 (UTF16) or 3 (UTF8) byte 'Byte Order Mark' at the start of the file to identify the file as being unicode.

You must also ensure that the import buffer size is defined so that it is long enough to hold the longest string in the import file, and you must ensure that the delimiter character used in the import file matches the one difined in SQL Assistant.

Mike Dempsey
Teradata Client Tools

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