Curve saving of characters in MySql via PHP. What to do?

Question

PHP

Table (utf8_general_ci).
PHP file making mysql_query() query in utf-8 without bom.
The data to this file is sent from the index.html form, which is also in utf-8

Answer 1

look towards SET character_set_client, SET character_set_connection SET character_set_result also see set names and collation
habrahabr.ru/post/10983

Answer 2

Had this problem helped
mysql_set_charset('utf8', $db);

Answer 3

Most likely, the reason is the epidemic disease of modern shkoloty: a fatal inability to trace cause-and-effect relationships. For example, if when viewing the data output from the database, they are displayed incorrectly, then it is concluded that they were recorded incorrectly. Or, as an option - the author himself makes some profound gestures in the code, not understanding their meaning - simply because the guys suggested the same way, and he stupidly copied - and they just spoil the data.
But in any case, the problem is in the inability to divide the process into stages, and control the data at each. In order to subsequently at least ask an adequate question, such as "When data is transferred from the browser, the data is corrupted." Or "when writing to the database, the data is corrupted." Instead, we get a helpless "Something is happening with the data, but what exactly and at what moment - I don't know."

Answer 4

He asked, he answered.
mysql_query("SET NAMES 'utf8'");
mysql_query("SET CHARSET SET 'utf8'");
mysql_query("SET SESSION collation_connection = 'utf8_general_ci'");