17.10 - Truncation Exceptions in ANSI Mode - 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)

In ANSI mode, truncation of non-pad characters assigned to a column returns an error. The pad character is determined by the target column type.

  • If during external-to-internal or explicit conversion the data to be placed in a fixed character column expands so that the column length is exceeded with non-pad characters, the Teradata Database returns an error.
  • If the fixed character column length is exceeded with pad characters, the Teradata Database truncates the input at the length of the column.
  • If data to be placed in a varying column expands so that the maximum column length is exceeded with non-pad characters, the Teradata Database returns an error.
  • If the varying character column maximum length is exceeded with pad characters, the Teradata Database truncates excess trailing pad characters.

Internal-to-external conversion is not affected by the mode of the Teradata Database. ANSI mode works the same as Teradata mode in this respect.