Truncation Exceptions in ANSI Mode - Teradata Database

International Character Set Support

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-09-25
dita:id
B035-1125
lifecycle
previous
Product Category
Teradata® Database

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.