PHP operation CSV file to import MySQL Chinese garbled solution

Use the online general method to read and upload the contents of the CSV file into the MySQL database, the Chinese display garbled, even if the data with Iconv function transcoding still garbled, then you can use the setlocale () function:

This function is used to configure the domain information, before reading and writing to the CSV data using this function to define, for example, my CSV file is a BOM-free UTF-8 format, the following functions are defined first:

SetLocale (Lc_all, ' ZH_CN. utf8′);

Then use the Iconv function to transcode the data contents and other subsequent operations.

PHP operation CSV file to import MySQL Chinese garbled solution