Data cleansing Note: Full-angle numeric Conversion

Data cleansing Note: Full-angle numeric Conversion

 

Background]

When you insert a numeric field to the target end, an error is returned, indicating that the type is incorrect. Check that the data is indeed number, but the result is a "fullwidth" number.

 

[Solution]

Use the function to convert the "fullwidth" to "halfwidth". Use the to_single_byte () function to convert it to halfwidth, and then store it in the database.

In addition, you can use the to_multi_byte () function if you need to convert the "halfwidth" to "fullwidth.

 

[Experiment]

Small knowledge, easy to remember.