|Oracle9i SQL Reference
Release 2 (9.2)
Part Number A96540-01
Functions, 158 of 177
UNISTR takes as its argument a string in any character set and returns it in Unicode in the database Unicode character set. To include UCS2 codepoint characters in the string, use the escape backslash (\) followed by the next number. To include the backslash itself, precede it with another backslash (\\).
This function is similar to the
USING function, except that
UNISTR offers the escape character for UCS2 codepoints and backslash characters.
The following example returns the Unicode equivalent of its character string: