16.20 - Translating HELP Report Data into the Session Character Set - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Teradata Database
Teradata Vantage NewSQL Engine
Release Number
March 2019
Content Type
Programming Reference
Publication ID
English (United States)

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.