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, VantageCloud Lake returns an error.
- If the fixed character column length is exceeded with pad characters, VantageCloud Lake 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, VantageCloud Lake returns an error.
- If the varying character column maximum length is exceeded with pad characters, the VantageCloud Lake 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.