UNISTR

Syntax

unistr::=

Text description of unistr

Purpose

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: Oracle9i Database Concepts for information on Unicode character sets and character semantics TRANSLATE ... USING

Examples

The following example returns the Unicode equivalent of its character string:

SELECT UNISTR('\00D6') FROM DUAL;

UN
--
Ö