Fgetcsv cannot read Chinese characters

Fgetcsv cannot read Chinese characters. setlocale (LC_ALL, 'zh _ CN ') has been set. However, when reading csv files, sometimes Chinese characters in the csv files cannot be read. why? It seems to be related to the system!

Reply to discussion (solution)

Is the document encoding the same as the system encoding? if they are different, iconv converts the document encoding to the system encoding.

I have used txt to save it as utf8!

Fgetcsv has a BUG.

Use this function.

function _fgetcsv(& $handle, $length = null, $d = ',', $e = '"') {     $d = preg_quote($d);     $e = preg_quote($e);     $_line = "";     $eof=false;     while ($eof != true) {         $_line .= (empty ($length) ? fgets($handle) : fgets($handle, $length));         $itemcnt = preg_match_all('/' . $e . '/', $_line, $dummy);         if ($itemcnt % 2 == 0)             $eof = true;     }     $_csv_line = preg_replace('/(?: |[ ])?$/', $d, trim($_line));     $_csv_pattern = '/(' . $e . '[^' . $e . ']*(?:' . $e . $e . '[^' . $e . ']*)*' . $e . '|[^' . $d . ']*)' . $d . '/';     preg_match_all($_csv_pattern, $_csv_line, $_csv_matches);     $_csv_data = $_csv_matches[1];     for ($_csv_i = 0; $_csv_i < count($_csv_data); $_csv_i++) {         $_csv_data[$_csv_i] = preg_replace('/^' . $e . '(.*)' . $e . '$/s', '$1' , $_csv_data[$_csv_i]);         $_csv_data[$_csv_i] = str_replace($e . $e, $e, $_csv_data[$_csv_i]);     }     return empty ($_line) ? false : $_csv_data;}

The bug of fgetcsv is that it cannot read Chinese characters...

Indeed, even if it is 5.3, the multi-byte support is still not very good.

It's actually a problem with php5.3.

The problem arises. it turns out that fgetcsv is not a problem. Microsoft's problem is that the format of the csv file saved in excel is incorrect. Originally, the csv file should use "" to enclose the values in cells, "," is used for segmentation, but the csv file generated in excel is not powerful enough to process Chinese characters. if something goes wrong, you can use notepad to open it.

@ Qizhiping: why can't I press your #7 Script? it seems that the csv file obtained by fgetcsv can be printed out in the array, but the Chinese file cannot be saved to the database.