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.