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

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

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.