Why are there crocozyabrs in the database?

Question

PHP

When writing information to the database in the database display through Myadmin, instead of the Cyrillic alphabet, Krokozyabry appears.
These are the ones. The only translator that translates them is Alexpad. And only line by line. says that the encoding is windows-1252. The display of information on the site is correct. It is necessary to alter this basis in a normal type (utf8). access to it only through Myadmin. If information is entered into the database through MyAdmin, then it is not displayed correctly. Wherever possible, the encoding is utf8. Notepad++ doesn't help. other translators that I found too.

Answer 1

As it turned out, the connection encoding was latin1 in the server settings, and the database encoding was utf8. Fixed a bug by loading a database dump into foxtool with an instruction to translate from Western European to utf8 and manual editing where service records were taken from the dump and translated data from the translator. Whether there was an easier way, I don't know. If anyone knows please share.

Answer 2

https://www.a2hosting.com/kb/developer-corner/mysq...

Answer 3

Oh, I suspect, in PHP scripts, after creating a connection to the database, it is written mysql_query("SET NAMES 'CP1251'");.
Or another option: mysqli_set_charset($db_connect, 'cp1251');.
Here it is written for her ...