17.10 - Example DBC.CharTranslationsV - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Advanced SQL Engine International Character Set Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
User Guide
Publication ID
B035-1125-171K
Language
English (United States)

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