TO_MULTI_BYTE

Oracle

TO_MULTI_BYTE(single_byte_char)

• single_byte_char: It is the NCHAR or NVARCHAR2 character that will be converted to a multibyte representation.

Example

SELECT TO_MULTI_BYTE('ABC')
FROM dual;

Output

'ABC'

Explanation

The TO_MULTI_BYTE function doesn’t change the string ‘ABC’ because it only contains ASCII characters which are already single-byte. This function is used to convert single-byte characters to their corresponding multi-byte characters. The dual table is a dummy table in Oracle.