MySQL database garbled problem, in order to check the following sequence, step by step to eliminate the error location.
It is best to use UTF8 encoding for all encodings .
Page page encoding using UTF8:
<meta http-equiv= "Content-type" content= "text/html; Charset=utf-8 "/>
Then check the connection to MySQL database when set to UTF8:
mysql_query ("Set character set ' UTF8 '", $con);
mysql_query ("Set NAMES ' UTF8 '", $con);
Check that the database Character Set is UTF8:UTF8---UTF-8 Unicode collation is:utf8_general_ci
Check that the character set for the table in the database is UTF8:UTF8--UTF-8 Unicode collation is:utf8_general_ci
The field character set for the check table in the database is UTF8:UTF8--the UTF-8 Unicode collation is:utf8_general_ci
After all the check is complete, you can test your project, if you have not changed the code before the addition of Chinese, you want to re-add Chinese data to normal display . I wish you success.
MySQL Database garbled problem