Oracle/PLSQL: To_Multi_Byte Function

In Oracle/PLSQL, the to_multi_byte function returns a character value with all of the single-byte characters converted to multibyte characters. To use this function, your database character set contains both single-byte and multibyte characters.

The syntax for the to_multi_byte function is:

to_multi_byte( char )

char can be a char, varchar2, nchar, or nvarchar2 value. This function will return its result in the same character set as char.

Applies To:

• Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g

For example:

select to_multi_byte('Tech on the net')
from dual;

The SQL statement above would return a multibyte character value.