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.
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!