How to restore encoding?

K

Konstantin Khairov2019-01-23 20:07:31

SQL

Konstantin Khairov, 2019-01-23 20:07:31

A database that is almost all on utf8_general_ci except for one table on win-1251 .
After a backup, it is not possible to restore this backup. I open backup in Notepad in Cyrillic the following picture

Screenshot

the file is opened and received as a UTF8-encoded file, but read as Unix(LF) for some reason. If you copy these characters and paste the browser, you get some Chinese characters
. Example: aﲲࡘ汧
How to be? How to fix it?

Reply

Answer the question

In order to leave comments, you need to log in

4 answer(s)

K

kot57ru, 2019-01-23
@kot57ru

You can find the answer on this site
https://www.shellhacks.com/en/linux-check-change-f... (Not advertising)

I

Ilshat Gayanov, 2019-01-23
@ilshat_gayanov

try in notepad++ utf8 without BOM

S

Sumor, 2019-01-23
@Sumor

Characters are displayed in hexadecimal codes Win1251
xC2xE5xEDxE5xF0xE0 is C2 E5 ED E5 F0 E0 is Venus
This means that the data in the file is not corrupted by transformations. They just need to be read in win1251 encoding.
It is quite possible that if you open the file explicitly with win1251 encoding, for example through notepad++, you will see the correct data.
How to restore them is still unknown, since you did not specify either the type of DBMS or how you made the backup.

V

Vapaamies, 2019-01-23
@vapaamies

You need to split the dump into TWO files, and open each in its own encoding. If the encodings are initially DIFFERENT, what are you trying to achieve with shamanistic rituals?