16.20 - Truncation Exceptions in ANSI Mode - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ NewSQL Engine International Character Set Support

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Configuration
User Guide
featnum
B035-1125-162K

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.