|Oracle® Database SQL Language Reference
11g Release 2 (11.2)
Part Number E17118-03
char with all of its multibyte characters converted to their corresponding single-byte characters.
char can be of data type
NVARCHAR2. The value returned is in the same data type as
Any multibyte characters in
char that have no single-byte equivalents appear in the output as multibyte characters. This function is useful only if your database character set contains both single-byte and multibyte characters.
This function does not support
CLOB data directly. However,
CLOBs can be passed in as arguments through implicit data conversion.
See Also:"Data Type Comparison Rules" for more information.
The following example illustrates going from a multibyte
A in UTF8 to a single byte ASCII
SELECT TO_SINGLE_BYTE( CHR(15711393)) FROM DUAL; T - A