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

This article is to share with you the reason why phpmyadmin imported csv garbled code. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

Why did phpmyadmin import csv garbled?

1. It is possible that the character set is different. Pay attention to character conversion.

2. The character set of csv may be gb2312, while the character set of database may be utf-8

3. Also pay attention to the character set of the PHP program code itself.

Solution:

The character set of the output web page. It is best to unify them all into utf-8. Before importing the data, you can transcode it through the editor and save it as a UTF-8-encoded csv file. (most editors have this feature), such as EditPlus. If imported through PHP, you can also use PHP's iconv to transcode.

Thank you for reading! This is the end of this article on "the reasons why phpmyadmin imported csv garbled code". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it out for more people to see!

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.