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.

Syntax

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 11g, Oracle 10g, Oracle 9i, Oracle 8i

For Example

select to_multi_byte('Tech on the net')

from dual;

The SQL statement above would return a multibyte character value.