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. |