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.