Purpose
UNISTR() converts text literals and Unicode encodings into strings in the national character set.
A Unicode encoded value is in the \xxxx format, where xxxx is a hexadecimal value (UCS-2 code unit) of a character in the UTF-16-encoded format. To include a backslash (\) in a string, add another backslash before it.
Syntax
UNISTR(string)
Parameters
The string parameter is a string of any character set.
Return type
This function returns a string.
Examples
The following example converts ASCII and Unicode encoded values to strings of 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