Implementing Custom Character Sets | Teradata Vantage - 17.20 - Implementing Custom Character Sets - Advanced SQL Engine - Teradata Database

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

Advanced SQL Engine
Teradata Database
Release Number
June 2022
Last Update
Content Type
User Guide
Publication ID
English (United States)
  1. Create the character set by defining:
    • The external-to-internal and internal-to-external hexadecimal codes for both lowercase and uppercase translation for each character in the set.
    • A unique character set name.
    • A unique identifier (use a value in the range 65 to 126).

      See Creating a Custom Client Character Set.

  2. Load the character set information into theDBC.CharTranslationsV. See Loading a Custom Client Character Set.
  3. Enable the character set. See Activating a Client Character Set.
    A maximum of 16 character sets can be active at one time.
  4. Optionally assign the character set as the default. See the section beginning with System Determination of Client Character Set.