Fgetcsv can't read Chinese

SetLocale (Lc_all, ' ZH_CN ') has been set, but sometimes it is not possible to read the Chinese in the CSV file, why? It seems to be related to the system system!

Reply to discussion (solution)

Document encoding and system coding are the same, iconv the document encoding into the system code.

I have saved txt as UTF8 format!

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 ', ' $ ', $_csv_data[$_csv_i]);     $_csv_data[$_csv_i] = Str_replace ($e. $e, $e, $_csv_data[$_csv_i]); } return empty ($_line)? False: $_csv_data;}

Fgetcsv Bug is not able to read Chinese ...

It's true, even if it's 5.3, the multi-byte support is not very good.

Actually, it's a php5.3 problem.

The problem comes out, originally not fgetcsv problem, Microsoft's problem, with Excel saved CSV file format is not correct, originally CSV file should use "" "to the value in cell surround, with", "to split, but with Excel generated CSV to Chinese character processing is not strong enough, So there is a problem, you can open it with a notepad to know.

@qizhiping: Why do I do as you do not have to do, as if fgetcsv to get a CSV file in the array can be printed out in Chinese, but Chinese is not stored in the database.

