Using phpmyadmin to import CSV files is garbled in Chinese. using phpmyadmin to import CSV files is garbled in Chinese ?? Urgent !!! ------ Solution -------------------- is the character set of the file correctly selected? ------ Solution ------------------ is it garbled to open the Chinese characters in the csv file using a text tool? ------ Solution --------- using phpmyadmin to import CSV files with garbled Chinese characters
Using phpmyadmin to import CSV files is garbled in Chinese ??
Urgent !!!
------ Solution --------------------
Is the character set of the file correctly selected?
------ Solution --------------------
Is it garbled to open the Chinese characters in the csv file using a text tool?
------ Solution --------------------
Discussion
No
Reference:
Is it garbled to open the Chinese characters in the csv file using a text tool?
------ Solution --------------------
Then you need to re-export the file according to the unified encoding method and re-import the database...
Otherwise, import the csv file in other tools to see if it is normal. for example, sqlyog. or navicat.
------ Solution --------------------
It doesn't matter if you see garbled characters in the database, because the encoding during data inventory is affected by the encoding of mysql_server.
Php is written in first and then read out. it is critical to see if there is no chaos.
Ensure csv and operating system encoding, which is consistent with mysql_client, mysql_connect, and mysql_reuslt.
------ Solution --------------------
I doubt whether the encoding you use in PHPMYADMIN is correct.
You can write a program and import it to the system.
------ Solution --------------------
You can downgrade the php version to 5.2.x !!!