How to open correctly a file saved in cp1251 on a site where all the encoding is utf8?

Question

PHP

In general, the essence is that the file is submitted and processed, it is a CSV file, and since it is saved in Excel, it is encoded in cp1251 at the output, and the entire site is encoded in utf8, how can this problem be correctly solved?

Answer 1

For example, you can do this:

$fh = fopen("file.csv", "r");
while (false !== $row = fgetcsv($fh, ...)) {
    foreach ($row as &$rowItem) {
        $rowItem = mb_convert_encoding($rowItem, "utf8", "cp1251");
    }
    unset($rowItem);
    ...
}
fclose($fh);

PS
Toster Driven Development

Answer 2

fi2.php.net/manual/en/function.mb-convert-encoding.php

Answer 3

probably only change on the fly
php.net/manual/ru/function.iconv.php
php.net/manual/ru/function.mb-convert-encoding.php