Truncation Examples - Teradata Database

International Character Set Support

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-09-25
dita:id
B035-1125
lifecycle
previous
Product Category
Teradata® Database

Consider a half-square Katakana string s4 which means ‘text’: (pronunciation te-ki-su-to). Suppose that a KanjiSJIS session stores s4 in a column csjis declared as CHAR(4) CHARACTER SET UNICODE.

The Teradata Database representation of the s4 string in UNICODE.

 

FF

83

FF

77

FF

7D

FF

84

Because Katakana characters are single-byte character in KanjiEBCDIC, a selection from a KanjiEBCDIC session is complete.

 

94

87

8E

95

Consider string s5 containing a half-square Katakana and a Kanji character (the half-square Katakana ‘a’ followed by the Kanji ‘yama’ for mountain).

Suppose that a KanjiSJIS session stores s5 in a column csjis declared as CHAR(3) CHARACTER SET KANJISJIS.

The Teradata Database representation of the s5 string in KANJISJIS is:

 

B1

8E

52

If column csjis is exported from a KanjiEUC session with the export width rule as n, the following data is exported (observe that expanded to two bytes and truncation on logical character boundary occurred for and padding took place).

 

8E

B1

20