when I write down INSERT INTO Cyrillic, then I have scribbles written to the database, but when I print these scribbles to the site, everything is normally Russian, and when I enter Cyrillic into the database from the phpmyadmin website, it draws scribbles on the site, can I correct my the problem and how to make it possible to read phpmyadmin on the phpmyadmin website: РкульР ° РєСЃРёРј
An example of a scrawl on my site:

    2 answers 2

    Add the following parameters to the mysqld section of the MySQL configuration file my.cnf.

    [mysqld] init_connect='SET collation_connection = utf8_general_ci' init_connect='SET NAMES utf8' default-character-set=utf8 character-set-server=utf8 collation-server=utf8_general_ci skip-character-set-client-handshake

    Specify the encoding utf8_general_ci for the database and tables. Restart MySQL.

    Specify UTF-8 encoding for the site.

     <meta charset="utf-8">
    • And where can I find this file (my.cnf)? - BedOmar
    • Found, inserted, restarted the server, and the server does not start - BedOmar
    • See the MySQL log. Try to comment out the last 2 lines. - Sequent

    Just need to register in bd.php or config.php:

     mysql_query("SET NAMES 'utf8'"); mysql_query("SET CHARACTER SET 'utf8'"); mysql_query("SET SESSION collation_connection = 'utf8_general_ci'");