16.10 - KanjiEUC Example - Teradata Database

Teradata Database International Character Set Support

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Configuration
User Guide
featnum
B035-1125-161K

For example, consider the following SELECT statement from a KanjiEUC session.

   SELECT 'Âgé';

The string Âgé is translated internally to UCS2.

00 C2 00 67 00 E9
 g é

Because this is three characters, the expected-defaults exports at most six bytes, but the representation of Âgé in KanjiEUC requires seven bytes.

8F AA A4 67 8F AB B1
 g é

Therefore, the output must be truncated to six bytes.

Truncation occurs at a character boundary, so the output is truncated to Âg, which requires four bytes.

If this were a fixed width field, these four bytes would be padded with SPACE characters to produce six bytes. Because the field is not fixed width, only four bytes are output (excluding the length information which is always included in variable width data).

8F AA A4 67
 g