Object Name and Title Data in HELP Reports | Teradata Vantage - 17.10 - Translating HELP Report Data into the Session Character Set - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Detailed Topics

Advanced SQL Engine
Teradata Database
Release Number
July 2021
English (United States)
Last Update

Attribute data reported as the result of a HELP request is translated from the data dictionary into the client session character set according to the following general guidelines, except as noted otherwise for individual HELP statements.

Most HELP attribute data is translated by the system from UNICODE into the session character set. For example:
  • Names and lists of names
  • Titles
  • Text fields, for example, Comment
  • Numeric values (translated from binary to UNICODE to the session character set)
  • The Format attribute
For some HELP attribute data, the system does not translate from UNICODE:
  • CHARACTER(1) and CHARACTER(2) fields, such as TVM Code or Data Type are translated from CHARACTER SET LATIN into the session character set.
  • Attributes that return one of a fixed group of values, for example State, which returns a value using UTF8(24).
  • Untranslatable character data that is returned as the UEscape character followed by a hex representation.
  • Legacy names that are not changed and remain in the form of their language support mode.