Answer the question
In order to leave comments, you need to log in
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
Answer the question
In order to leave comments, you need to log in
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 questionAsk a Question
731 491 924 answers to any question