17.10 - Implicit Character-to-Character Conversion - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Data Types and Literals

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1143-171K
Language
English (United States)

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