17.10 - Example: Using CharTranslationsV - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Programming Reference
Publication ID
B035-1092-171K
Language
English (United States)

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...