17.00 - Example: Using CharTranslationsV - Teradata Database

Teradata Vantage™ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K

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