Archives of the TeradataForum
Message Posted: Fri, 16 May 2003 @ 20:30:18 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|