Shulou(Shulou.com)06/01 Report--

Editor to share with you phpMyAdmin import csv Chinese garbled solution, I hope you will gain something after reading this article, let's discuss it together!

What if phpMyAdmin imports Chinese garbled code into csv?

The data CSV file with Chinese fields is used in the project, and the garbled Chinese content is found in the imported Mysql data.

Analyze the reason: it is caused by the problem of database character encoding.

The solution is as follows:

[1] create a utf-8 character set database

CREATE DATABASE db_name DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci

[2] change the character encoding of the database

ALTER DATABASE db_name DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci

As above, it is normal after changing the character encoding of the data.

After reading this article, I believe you have a certain understanding of "the solution of phpMyAdmin importing csv Chinese garbled code". If you want to know more about it, you are welcome to follow the industry information channel. Thank you for your reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.