15.10 - CharTranslationsV - Teradata Database

Teradata Database Data Dictionary

Product
Teradata Database
Release Number
15.10
Content Type
Administration
User Guide
Publication ID
B035-1092-151K
Language
English (United States)

Operations

DBC

 

View Column

Data Type

Format

Source Table.Column

CharSetName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

Translation.TranslateName (UPI)

CharSetId

BYTEINT

NOT NULL

ZZ9 (explicit)

Translation.TranslateId

InstallFlag

CHAR(1) LATIN

UPPERCASE

NOT CASESPECIFIC

NOT NULL

X(1)

Translation.Install

E2I

BYTE(256)

NOT NULL

X(512)

Translation.TranslateIn

E2IUp

BYTE(256)

NOT NULL

X(512)

Translation.TranslateInUp

I2E

BYTE(256)

NOT NULL

X(512)

Translation.TranslateOut

I2EUp

BYTE(256)

NOT NULL

X(512)

Translation.TranslateOutUp

If client system connections are to use the defined character sets, the Teradata Database system administrator specifies which character set is assigned to which client system (see “HostsInfoV” on page 154). Otherwise, the standard default is used. Also, the user may specify a defined character set after a session is started (see “CharSetsV” on page 79).

When specifying a character set for a session, the choice should be compatible with the internal code of the logon client system; that is, an EBCDIC‑compatible character set for sessions initiated from an IBM mainframe, ASCII‑compatible sets for all others. It is suggested, therefore, that a convention be used for naming character sets which differentiates between EBCDIC and ASCII compatibility (see the example below).

CharSetId

If the character set is user-defined, the ID should also exist in DBC.CharTranslations.CharSetID.

For constraints not involving comparison of character data or not using CHARSET_COLL for evaluation, the value is NULL.

InstallFlag

The Teradata Database must be reset to install the rows containing a Y in the InstallFlag field. If the value of InstallFlag is Y in 12 rows or fewer, each Y row is loaded. If InstallFlag is Y in more than 12 rows, then the CharSetName values are sorted in ascending ASCII sequence, and rows are loaded in alphabetical order until 12 sets are installed or the names are exhausted.

The example below shows that the hexadecimal translation tables for 6 character sets have been defined, and that two of these are flagged for loading.

==> SELECT * FROM DBC.CharTranslationsV;

 

Result:

CharSetName      ­Set Id   ­Flag    ­E2I
---------------- ------   -----   --------------------------
German_EBCDIC    100      N       00010203A809A97FD1D2D3...
Italian_EBCDIC   105      N       00010203A809A97F2395EE...
Spanish_EBCDIC   103      N       00010203A809A97FD1D2D3...
French_EBCDIC    104      Y       00010203A809A97FD1D2D3...
Norwegian_EBCDIC 101      N       00010203A809A97FD1D2D3...
Swedish_EBCDIC   102      Y       00010203A809A97FD1D2D3...