TO_MULTI_BYTE Function in Oracle SQL – PLSQL

The TO_MULTI_BYTE function in Oracle SQL / PLSQL is used to get a character value with all the single byte characters converted to multi byte characters.

To use TO_MULTI_BYTE function make sure that the data base contains both single and multi byte characters.

The Syntax for the TO_MULTI_BYTE function in Oracle SQL / PLSQL is:

SELECT TO_MULTI_BYTE(character1)
FROM table_name;

  • character1 can be of any type like char, varchar2, nchar or nvarchar2
  • The return type of TO_MULTI_BYTE function will be of the same data type as that of the character1.

Example 1:

SELECT TO_MULTI_BYTE ('Tech Honey')
FROM dual;

Will return the multi byte character value of ‘Tech Honey’


Tagged , , , , , , , , , , , . Bookmark the permalink.
  • Guest

    Good Post