16.10 - Explanation of Example - Teradata Database

Teradata Database International Character Set Support

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Configuration
User Guide
featnum
B035-1125-161K
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.