How to convert half-width to full-width in Oracle

In Oracle, you can use the "to_multi_byte()" function to convert half-width to full-width. This function can replace all single-byte characters with equivalent multi-byte characters in String. The syntax is "select to_multi_byte ('string') text from dual".

The operating environment of this tutorial: linux7.3 system, Oracle 11g version, Dell G3 computer.

How to convert half-width to full-width in oracle

TO_MULTI_BYTE

Syntax:

 TO_MULTI_BYTE(String)

Function: Convert half-width in string to full-width

Calculate a String in which all single-byte characters are replaced with equivalent multi-byte characters. This function is only valid when the database character set contains both multi-byte and single-byte characters. Otherwise, String will not be processed in any way. . TO_MULTI_BYTE and TO_SINGLE_BYTE are two opposite functions.

SQL> select to_multi_byte('test') from dual;

Recommended tutorial: "Oracle Video Tutorial"

The above is the detailed content of How to convert half-width to full-width in Oracle. For more information, please follow other related articles on the PHP Chinese website!