D
D
DmitryLife2020-02-23 17:50:34
PHP
DmitryLife, 2020-02-23 17:50:34

Why are incorrect characters displayed in PHPMyadmin DB?

Good afternoon.

Problem following:
At transfer of a DB, all Cyrillic characters moved down. At the same time, I manually set the encoding utf8_general_ci everywhere. The site also has UTF8 encoding.

I can't figure out what the problem is

5e529128654ed295838318.png

5e52912dd7633886017078.png

Answer the question

In order to leave comments, you need to log in

1 answer(s)
N
nokimaro, 2020-02-23
@nokimaro

If the data was broken during the transfer, then changing the encoding after the fact may not help.
1. You need to check the contents of the dump. Since there may be a problem in how the data is stored there.
2. Re-upload the dump over a new
one. If you, suppose the table was in latin or cp1251 in the old database, you made a dump. He is also in latin. If you upload it to a new database that is set to utf8, then the dump will never upload correctly.
There is not enough information on the original data. But for the case if the data was in 1251 and now we want utf8, then the contents of the dump can be converted using iconv or enconv

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question