|Oracle9i SQL Reference
Release 2 (9.2)
Part Number A96540-02
char with all of its single-byte characters converted to their corresponding multibyte characters.
char can be of datatype
NVARCHAR2. The value returned is in the same datatype as
Any single-byte characters in
char that have no multibyte equivalents appear in the output string as single-byte characters. This function is useful only if your database character set contains both single-byte and multibyte characters.
This function does not support
The following example illustrates converting from a single byte 'A' to a multibyte 'A' in UTF8: