15.10 - Truncation Examples - 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

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