15.10 - About the DBC.CharTranslationsV View - Teradata Database

Teradata Database International Character Set Support

prodname
Teradata Database
vrm_release
15.00
15.10
category
Configuration
User Guide
featnum
B035-1125-015K

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:

  • Y= Enables the translation codes for the CharSetName at the next restart of the Teradata Database.
  • N=The translation codes for the CharSetName are disabled.
  • 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.