Example: Using CharTranslationsV - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

The following example 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...