The session transaction mode affects character string truncation.
|IF the session transaction mode is …||THEN an input character string that requires truncation is truncated …|
|Teradata||without reporting an error. Truncation on Kanji1 character strings containing multibyte characters might result in truncation of one byte of the multibyte character.|
|ANSI||of excess pad characters without reporting an error. Truncation of other characters results in a truncation exception.|
The normal truncation rules apply to a result string. For more information, see Teradata Vantage™ - Data Types and Literals, B035-1143.