Oracle/PLSQL: To_Single_Byte Function

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

The syntax for the to_single_byte function is:

to_single_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_single_byte('Tech on the net')
from dual;

The SQL statement above would return a single-byte character value.