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

International Character Set Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-28
dita:mapPath
xnf1627504141606.ditamap
dita:ditavalPath
xnf1627504141606.ditaval
dita:id
B035-1125
lifecycle
previous
Product Category
Teradata Vantageā„¢

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.