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.