Implicit Character-to-Character Translation | Teradata Vantage - 17.10 - Character Literals - 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)

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.