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 “Character Truncation Rules” in Teradata Vantage™ - Data Types and Literals, B035-1143.