The session transaction mode affects character string truncation when the function is passed a CHAR or VARCHAR input argument or returns a CHAR result that exceeds the maximum length specified in the CREATE FUNCTION or REPLACE FUNCTION statement.
| Session Transaction Mode | Character String Truncation |
|---|---|
| Teradata | Vantage truncates the argument or result without reporting an error. Truncation on Kanji1 character strings containing multibyte characters may result in truncation of one byte of the multibyte character. |
| ANSI | Vantage truncates the argument or result of excess pad characters without reporting an error. Truncation of other characters results in a truncation exception. |