16.20 - Explanation of Example - Teradata Vantage NewSQL Engine

Teradata Vantage™ NewSQL Engine International Character Set Support

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Configuration
User Guide
featnum
B035-1125-162K
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.