UNISTR

UNISTR converts a text string to the national character set.

Return Value

NVARCHAR2

Syntax

UNISTR ( string )

Arguments

string can be any text expression. For portability, Oracle recommends using only ASCII characters and Unicode encoding values as text literals. A Unicode encoding value has the form \xxxx where xxxx is the hexadecimal value of a character. Supplementary characters are encoded as two code units, the first from the high-surrogates range (U+D800 to U+DBFF), and the second from the low-surrogates range (U+DC00 to U+DFFF). To include a literal backslash in the string, precede it with another backslash (\\).

Example

UNISTR('abc\00e5\00f1\00f6') returns the value abcåñö.