17.10 - Truncation and Transaction Mode - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Advanced SQL Engine International Character Set Support

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
User Guide
Publication ID
English (United States)

The behavior of the truncation depends upon whether the conversion occurs while the Teradata Database is operating in Teradata mode or ANSI mode. For more information, see Truncation Exceptions in ANSI Mode and Truncation Exceptions in Teradata Mode.

In this mode … Truncation of this server character set is as follows …
ANSI non-pad character data causes an error.
Teradata character data is truncated without reporting an error.