Implicit Expression/Function Argument Translation | Teradata Vantage - 17.10 - SQL Rules for Implicit Translation for Expression and Function Arguments - 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 are the rules for implicit translation between types of expressions and function arguments.

For string functions that produce a character result, the results are summarized by the following table.

FOR this function … The result is …
TRIM converted back to the type of the main string argument (last argument).
|| (concatenation) not translated and remains with the character data type of the arguments after any implicit translation.

Note that the other string functions either do not involve conversion or the type of the result is based on the function and not the server character set of the argument.

For example, in the following TRIM function, <unicode-literal> is first translated to Latin, and then the trim operation is performed.

...
TRIM(<unicode-literal> FROM <latin-value>)

The result is Latin.