Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

Subj:   Re: Teradata Admin 6.0.-Comment String Question
From:   Dempsey, Mike

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
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016