16.20 - Character Truncation Rules - Teradata Vantage NewSQL Engine

Teradata Vantage™ Data Types and Literals

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1143-162K

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.