From xml(utf-8) to db(cp-1251)?

Question

PHP

Hello.
There is data in the xml file in utf-8 encoding. Parsed xml in php and inserted into the database.
But when I had to insert it into the database with the cp-1251 encoding, the bugs started.
Through Notepad I changed the encoding, and chose to use 'ANSI' - all the same, only krakozyabry.
How to get rid of krakozyabr?
Thanks in advance.

Answer 1

set names utf8

Answer 2

how do you parse xml?

Answer 3

You need to convert the data to the format of your database, because Cyrillic characters in ANSI, UTF-8 and CP-1251 are different.

$data = { parse xml}
foreach ($data as $key => $value) {
         if (!mb_check_encoding($value, 'Windows-1251')) {
                    $data[$key] = mb_convert_encoding($value, 'UTF-8', 'Windows-1251');
          }
}
{insert data to $db}