Purpose
This function converts text literals and Unicode encoded values to strings in the national character set.
Unicode encoded values are in the format \xxxx, where xxxx is the hexadecimal value of the character in UCS-2 (UTF-16 code unit) encoding. To include a backslash in the string itself, you must use two backslashes (\\).
Syntax
UNISTR(string)
Parameters
The string parameter is a string in any character set.
Return type
Returns a string value.
Examples
Convert ASCII characters and Unicode encoded values to strings in the national character set.
obclient> SELECT UNISTR('A B C \FF20 \00C4 \00CA \00CD \00D5 \00D8') FROM DUAL;
+---------------------------------------------+
| UNISTR('ABC\FF20\00C4\00CA\00CD\00D5\00D8') |
+---------------------------------------------+
| A B C ＠ Ä Ê Í Õ Ø |
+---------------------------------------------+
1 row in set