BEX5 development tips for MySQL incorrect string value

A lot of test data is often used in MySQL development, and the simplest way to start a build tool is to use Excel. On the other hand, many of the MySQL client graphical management tools support importing. csv files into a MySQL table. However, MySQL table encoding is generally in UTF-8 format, and on the other hand, Excel exports a. csv file that is not in UTF-8 format by default. Therefore, before importing this. csv file into a MySQL table, you need to check or convert it to the UTF-8 format first.

I believe many of my friends are familiar with text editors like notepad++. Using such a tool, you can easily open the above. csv file and convert it to UTF-8 format first. Finally, save it again, then import into the MySQL target table is generally careful and generally no problem. Please refer to.

650) this.width=650; "Src=" https://s2.51cto.com/wyfs02/M02/8D/6B/wKioL1ib9yDDVWV7AANBhfSQ1c8582.jpg-wh_500x0-wm_ 3-wmp_4-s_589442669.jpg "title=" Untitled. jpg "alt=" wkiol1ib9yddvwv7aanbhfsq1c8582.jpg-wh_50 "/>

This article is from the "Green Peak" blog, please make sure to keep this source http://zhuxianzhong.blog.51cto.com/157061/1896338

BEX5 development tips for MySQL incorrect string value