Implicit Character-to-Character Translation | Teradata Vantage - Character Literals - Advanced SQL Engine - Teradata Database

SQL Data Types and Literals

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
zsn1556242031050.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1143
lifecycle
previous
Product Category
Teradata Vantage™

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.