17.10 - Explanation of Example - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Advanced SQL Engine International Character Set Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
User Guide
Publication ID
B035-1125-171K
Language
English (United States)
Field Attributes Description
CharSetName (TranslateName) VARCHAR(128) NOT NULL A name that uniquely identifies a character set.

Character set names should start with an unaccented uppercase Roman letter and consist of only unaccented uppercase Roman letters, digits, underscore, dollar sign, or number sign.

CharSetID (TranslateID) BYTEINT NOT NULL A number that uniquely identifies the character set for which these translation codes are being inserted.

Each character set ID must be in the range 65–126.

InstallFlag (Install) CHAR(1) NOT NULL A value of either Y or N, where:
  • Y= Enables the translation codes for the CharSetName at the next restart of the Teradata Database.
  • N=The translation codes for the CharSetName are disabled.

A maximum of 16 character sets can be enabled at one time.

E2I (TranslateIn) BYTE(256) NOT NULL The external (host)-to-internal (Teradata Database) codes for each character in the set.
E2IUp (TranslateInUp) BYTE(256) NOT NULL The external-to-internal uppercase codes for each character in the set.
I2E (TranslateOut) BYTE(256) NOT NULL The internal (Teradata Database)-to-external (client) codes for each character in the set.
I2EUp (TranslateOutUp) BYTE(256) NOT NULL The internal-to-external uppercase codes for each character in the set.