16.20 - Result Type and Attributes - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1145-162K
Language
English (United States)

The default attributes for TRANSLATE (string USING source _TO_target) are as follows:

  • If the argument is CHAR or VARCHAR, the result is VARCHAR(n) or CHARACTER SET target
  • If the argument is CLOB, the result is CLOB(n) or CHARACTER SET target

where source_TO_target determines the character set value of target, according to the supported translations in “Supported Translations Between Character Sets”.

If the string USING source _TO_target argument is null, the result is null.