How to change encoding when importing into mysql from csv file?

Question

PHP

Good day to all.
add row to db

$handle = fopen($file, "r");
        while (($line = fgetcsv($handle, 100, ";")) !== FALSE) {

            $query = $db->prepare("INSERT INTO students (name,surname,age,city) VALUES (:name,:surname,:age,:city)");
            $data = array('name' => $line[0], 'surname' => $line[1], 'age' => $line[2], 'city' => $line[3]);
            $query->execute($data);
        }
        fclose($handle);

But if there is Cyrillic in csv, just an empty line is added
. Example of a csv file:

How can I change the encoding of a csv file?
Thank you in advance for your response.

Answer 1

Before importing, specify in the code:
There are other ways to import:

1. LOAD DATA LOCAL INFILE
   
2. mysqlimport
   
3. HeidiSQL
   

Answer 2

Not the file encoding, but the connection encoding.
What is the csv encoding?
If utf, then accordingly execute SET NAMES utf8
Before inserting into the database