Implicit Character-to-Character Conversion

Teradata Vantage™ Data Types and Literals

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

CLOB types can only be converted to or from CHAR or VARCHAR types. For example, implicit conversion is performed on CLOB data that is inserted into a CHAR or VARCHAR column. SeeImplicit Type Conversions.

Comparisons of strings, fixed- or variable-length, require operands of equal length. The following table shows that the shorter string is converted by being padded on the right.

Expression Conversion Result
'x'='x ' 'xΔ '='x ' TRUE
'x'='xx' 'xΔ '='xx' FALSE

where Δ is a pad character.

If a character is not in the repertoire of the target character set, an error is reported.