Client Character Set Translation Codes | Teradata Vantage - 17.20 - Client Character Set Translation Codes - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Advanced SQL Engine International Character Set Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.20
Published
June 2022
Last Update
2022-06-24
Content Type
Configuration
User Guide
Publication ID
B035-1125-172K
Language
English (United States)

When Advanced SQL Engine 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.

Vantage 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 Advanced SQL Engine server character set.

Translation codes also define how to convert characters to uppercase, for example when Advanced SQL Engine 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 (Vantage)
  • External-to-internal uppercase
  • Internal (Vantage) to External (Client)
  • Internal-to-external uppercase
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 Vantage system. Only 16 character sets can be active at a time.