Archives of the TeradataForum

Message Posted: Fri, 16 May 2003 @ 20:30:18 GMT

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

You are correct about Unicode characters.

Both Queryman (Teradata SQL Assistant) and WinDDI (Teradata Administrator) will truncate data at the first null byte [This was required to support Japanese characters using the standard VB string interface.]. Since every alternate byte is a null in an English Unicode string they would indeed truncate the string and display a single character.

The emails however stated that the character set was 'Latin' - I have asked them (off-list) to confirm this.

Note that this data truncation has also caused problems for some mainframe users who seem to have nulls dotted around in strings that are loaded from the mainframe but read using Queryman.

The next version of Teradata SQL Assistant (6.2) uses a different interface to to ODBC driver and will no longer truncate at null characters.

Mike Dempsey
Teradata Client Tools
Developer - Teradata Administrator / SQL Assistant

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