To be available for use, a client character set must be listed in the DBC.CharTranslationsV view and the Install Flag must be set to Y.
Note: The ASCII, EBCDIC, UTF8 and UTF16 client character sets are permanently enabled and do not appear in DBC.CharTranslationsV.
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..
Field |
Attributes |
Description |
CharSetName (TranslateName) |
VARCHAR(128) NOT NULL |
A name that uniquely identifies a character set. Character set names should start with an unaccented uppercase Roman letter and consist of only unaccented uppercase Roman letters, digits, underscore, dollar sign, or number sign. |
CharSetID (TranslateID) |
BYTEINT NOT NULL |
A number that uniquely identifies the character set for which these translation codes are being inserted. Each character set ID must be in the range 65–126. |
InstallFlag (Install) |
CHAR(1) NOT NULL |
A value of either Y or N, where: A maximum of 16 character sets can be enabled at one time. |
E2I (TranslateIn) |
BYTE(256) NOT NULL |
The external (host)-to-internal (Teradata Database) codes for each character in the set. |
E2IUp (TranslateInUp) |
BYTE(256) NOT NULL |
The external-to-internal uppercase codes for each character in the set. |
I2E (TranslateOut) |
BYTE(256) NOT NULL |
The internal (Teradata Database)-to-external (client) codes for each character in the set. |
I2EUp (TranslateOutUp) |
BYTE(256) NOT NULL |
The internal-to-external uppercase codes for each character in the set. |
For more information on DBC.CharTranslationsV, see Data Dictionary.