Truncation Exceptions in ANSI Mode - Analytics Database - Teradata Vantage

Teradata Vantageā„¢ - Analytics Database International Character Set Support - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-01-27
dita:mapPath
aju1628095815656.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
hqj1472245413611
Product Category
Teradata Vantage

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, Vantage returns an error.
  • If the fixed character column length is exceeded with pad characters, Vantage 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, Vantage returns an error.
  • If the varying character column maximum length is exceeded with pad characters, Vantage truncates excess trailing pad characters.

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