The following rules apply to character strings.
| IF the string is cast in this mode … | THEN it is truncated of … |
|---|---|
| ANSI | trailing pad character spaces to achieve the desired length. Truncation of other characters, or part of a multibyte character, returns an error. |
| Teradata | trailing characters to achieve the desired length. Truncation on Kanji1 character data types containing multibyte characters might result in truncating one byte of the multibyte character. |