How to read csv (shift jis win) mixed with Chinese and Japanese in php

Why don't you put a BOM on the CSV?

CSV output code

<?php

$fp = fopen('test.csv', 'wb');

$list = [
    ["Words", "Chinese translation"]
    ["Hello", "I like you"]
    ['Thank you', '谢啦谢']
];

// Prepend BOM
fputs($fp,$bom=(chr(0xEF).chr(0xBB).chr(0xBF)));

foreach($list as$fields){
    fputcsv($fp,$fields);
}

fclose($fp);

CSV input code

<?php

$fp = fopen('test.csv', 'r');
$bom=chr(0xEF).chr(0xBB).chr(0xBF);

if($fp!==FALSE){
    $encoding='UTF-8';
    if(fgets($fp,4)!==$bom){
        refresh($fp);
        $encoding='SJIS-WIN';
    }

    while($data=fgetcsv($fp))!==FALSE){
        foreach($data as$value){
            mb_convert_variables('UTF-8', $encoding, $value);
            echo "${value},";
        }
        echo "\n";
    }

    fclose($fp);
}

Shift_JIS (and CP932, which includes extensions by MS) does not contain Chinese characters such as 」, 」, and 」.Therefore, there is no Shift_JIS CSV file containing at least these characters.

As far as the hexadecimal dump is concerned, all characters that cannot be represented as Shift_JIS have been converted to literal ?(3f) at the CSV stage, and the original Chinese information has already been lost.So you'll need to rethink how to save it to CSV.

The reason why CSVs need to be saved and they are tied to Shift_JIS is that most of them want to view/check CSVs stored in Excel.Excel can read UTF-8 CSV files correctly only if a BOM is granted.

The code above is a PHP copy of that Excel habit.Make the input code compatible with UTF-8 with BOM so that you can read the existing Shift_JIS CSV for compatibility.