15.10 - About Client Character Set Translation Codes - Teradata Database

Teradata Database International Character Set Support

Teradata Database
User Guide

When Teradata Database processes a client request, it translates client character data to the default server character set. Then, when returning an answer set, the database translates character data from the server character set back to the client character set.

Teradata Database provides the necessary translation codes for processing data from several common client character sets. Each translation code maps the characters in a client character set to the equivalent characters in a compatible Teradata Database server character set.

Translation codes also define how to convert characters to uppercase, for example when the Teradata Database stores characters in a column that is defined as UPPERCASE.

Four hexadecimal translation codes are required for each combination of a client character set and compatible server character set:

  • External (Client) to Internal (Teradata Database)
  • External-to-internal uppercase
  • Internal (Teradata Database) to External (Client)
  • Internal-to-external uppercase
  • Note: A client character set is usable only if it is specified as the client default, and if the corresponding character translation code is installed and enabled on the Teradata Database system. Only 16 character sets can be active at a time.


    For information on...


    Teradata support for commonly used client character sets

  • “Permanently Enabled Client Character Set Support” on page 22
  • “Support of Other Client Character Sets” on page 22
  • Enabling use of a client character set

    “Enabling a Client Character Set” on page 55.

    Setting the default client character set

    “System Determination of Client Character Set” on page 55.

    Creating a custom (site-defined) client character set

  • Chapter 5: “Site-Defined Client Character Sets.”
  • Chapter 6: “Extended Site-Defined Client Character Sets.”