Implicit string translation occurs when two character strings are incompatible within a given operation. For example:
SELECT * FROM string_table WHERE clatin < csjis;
where clatin represents a character column defined as CHARACTER SET LATIN and csjis represents a character column defined as CHARACTER SET KANJISJIS.
If an implicit translation of character string string to a UNICODE character string is required, the implicit translation is equivalent to running the TRANSLATE (string USING source_repertoire_name_TO_Unicode) function, where source-repertoire-name is the server character set of string.
More specifically, if as in the preceding example, string is of KANJISJIS type, then the translation is equivalent to executing the TRANSLATE (string USING KanjiSJIS_TO_Unicode) function.
- Character Literals
- Implicit KANJISJIS Character-to-Character Translation
- SQL Rules for Implicit Translation for Expression and Function Arguments
ANSI Compliance
This is a Teradata extension to the ANSI SQL:2011 standard.