Result Type and Attributes

Teradata Vantage™ SQL Functions, Expressions, and Predicates

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1145-162K

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.