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

Teradata Vantage™ - SQL Functions, Expressions, and Predicates

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
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.