Solve phpcsv file import mysql Chinese garbled

Solve phpcsv file import mysql Chinese garbled

When using php to import csv files to the mysql database, Chinese characters are garbled. here is the solution. For more information, see. Many methods are used to read and upload csv files to the mysql database. Chinese characters may display garbled characters, even if the data is transcoded using the iconv function. You can use the setlocale () function for processing. This function is used to configure the region information, before reading and writing csv data, first use this function to define, for example, csv file is a UTF-8 format without BOM, you can first use the following function definition: setlocale (LC_ALL, 'zh _ CN. utf8 ′); Then, use the iconv function to transcode the data content to the database, and then perform subsequent operations.