The session transaction mode affects character string truncation.
| IF the session transaction mode is … | AND the function … | THEN Teradata Database … |
|---|---|---|
| Teradata | 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 | truncates the argument or result without reporting an error. Truncation on Kanji1 character strings containing multibyte characters might result in truncation of one byte of the multibyte character. |
| ANSI | 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 | truncates the argument or result of excess pad characters without reporting an error. Truncation of other characters results in a truncation exception. |