Oracle9i SQL Reference Release 1 (9.0.1) Part Number A90125-01 |
|
Functions, 155 of 166
unistr::=
unistr
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 TRANSLATE
... USING
function, except that UNISTR
offers the escape character for UCS2 codepoints and backslash characters.
See Also:
|
The following example returns the unicode equivalent of its character string:
SELECT unistr('\00D6') FROM DUAL; UN -- Ö
|
![]() Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|