Example DBC.CharTranslationsV - Advanced SQL Engine - Teradata Database

International Character Set Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-28
dita:mapPath
xnf1627504141606.ditamap
dita:ditavalPath
xnf1627504141606.ditaval
dita:id
B035-1125
lifecycle
previous
Product Category
Teradata Vantage™

The following example shows the DBC.CharTranslationsV view in the default state, that is, with none of the standard Teradata client character set translation codes enabled.

SELECT * FROM DBC.CharTranslationsV;
*** Query completed. 29 rows found. 7 columns returned.
*** Time was 3.60 seconds.
   CharSetName         CharSetId  InstallFlag E2I 
   ---------------     ---------  ----------- ------------------
   KATAKANAEBCDIC      111        N           000102039409967F..
   SCHINESE936_6R0     115        N           0001020304050607..
   HANGULKSC5601_2R4   120        N           0001020304050607..
   EBCDIC273_0E         97        N           000102039C09867F..
   EBCDIC037_0E         96        N           000102039C09867F..
   KANJIEBCDIC5035_0I  113        N           000102039C09867F..
   LATIN1_0A           126        N           0001020304050607..
   TCHEBCDIC937_3IB    110        N           0001020304050607..
   KANJISJIS_0S        119        N           0001020304050607..
   LATIN1252_3A0       123        N           0001020304050607..
   KANJIEBCDIC5026_0I  112        N           000102039C09867F..
   HEBREW1255_5A0      103        N           0001020304050607..
   ARABIC1256_6A0      104        N           0001020304050607..
   KANJIEUC_0U         118        N           0001020304050607..
   LATIN9_0A           125        N           0001020304050607..
   CYRILLIC1251_2A0    102        N           0001020304050607..
   THAI874_4A0         100        N           0001020304050607..
   LATIN1250_1A0       101        N           0001020304050607..
   HANGUL949_7R0       116        N           0001020304050607..
   SCHGB2312_1T0       121        N           0001020304050607..
   LATIN1254_7A0       105        N           0001020304050607..
   SCHEBCDIC935_2IJ    109        N           0001020304050607..
   TCHINESE950_8R0     117        N           0001020304050607..
   HANGULEBCDIC933_1II 108        N           0001020304050607..
   EBCDIC277_0E         98        N           000102039C09867F..
   LATIN1258_8A0       106        N           0001020304050607..
   LATIN1252_0A        124        N           0001020304050607..
   TCHBIG5_1R0         122        N           0001020304050607..
   KANJI932_1S0        114        N           0001020304050607..