Character Literals

Teradata Vantage™ Data Types and Literals

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

The following rules apply to implicit character-to-character translation involving character literals.

IF one operand is a … AND the other operand is a … THEN …
literal literal both operands are translated to UNICODE.
non-literal the literal is translated to the type of the non-literal. If that fails, both are translated to UNICODE.
literal expression the literal is translated to the type of the literal expression. If that fails, both are translated to UNICODE.
literal expression literal expression both operands are translated to UNICODE.
non-literal the literal expression is translated to the type of the non-literal. If that fails, both are translated to UNICODE.
non-literal non-literal both operands are translated to UNICODE.