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;
Result:
*** 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..