The default attributes for TRANSLATE (string USING source _TO_target) are as follows:
| Argument Data Type | Result type |
|---|---|
| CHAR or VARCHAR | VARCHAR(n) or CHARACTER SET target |
| CLOB | CLOB(n) or CHARACTER SET target |
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.