How to fix encoding in CSV?

Question

PHP

I write to a file and upload CSV in this way:

$data = [
  'Товар 1;some;3',
  'Товар 2;anather;6',
  'Товар 3;test;9'
];

header('Content-Type: text/csv');
header('Content-disposition: attachment;filename=data.csv');
foreach ($data as $row) {
  echo $row, PHP_EOL;
}

At the output, I get krakozyabry in Russian characters . I
tried it with the iconv("utf-8", "windows-1251", $string) function;
Displays Russian characters, but the first character is lost or distorted. "Set" instead of "Set"

Answer 1

<?php
    $data = [
      'Товар 1;some;3',
      'Товар 2;anather;6',
      'Товар 3;test;9'
    ];

    header('Content-Type: text/csv');
    header('Content-disposition: attachment;filename=data.csv');
    foreach ($data as $row) {
      echo mb_convert_encoding($row, 'CP1251', mb_detect_encoding($row)), PHP_EOL;
    }

Answer 2

Try saving the file itself in UTF-8 encoding