17.10 - Truncation Exceptions When Converting Fixed Length Columns - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Advanced SQL Engine International Character Set Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
User Guide
Publication ID
B035-1125-171K
Language
English (United States)

Sharing the fixed length KANJISJIS server character set fields involves a different problem. The applications need to place enough padding within the field so that when it is converted to a different form-of-use, say KANJISJIS to KanjiEUC character set, the meaningful characters in the string are not truncated.

Truncation due to conversion and length change does not occur for KANJI1 server character set fields.

Because of the length change problem, you should use varying character fields when different representations can vary in length.