16.20 - Example: Using CharTranslationsV - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ Data Dictionary

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-03
dita:mapPath
zzu1512081120577.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

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