15.00 - Working with Object Name and Title Data in HELP Reports - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Teradata Database
Release Number
Content Type
Programming Reference
Publication ID
English (United States)

Working with Object Name and Title Data in HELP Reports

Translating HELP Report Data into the Session Character Set

Attribute data reported as the result of a HELP request is translated from the data dictionary into the session (client) 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. See Rules for HELP Report Names and Titles.
  • Legacy names that are not changed and remain in the form of their language support mode.