How to set the encoding method when php connects to mysql?

When php connects to the mysql database, add the "mysql_query("set names utf8");" statement after the mysql_connect() statement to set the encoding method. Note: It is utf8, not utf-8; it is also best to use utf-8 for the web page character set.

When PHP connects to the database, that is, add

//设置数据的字符集utf-8
mysql_query("set names 'utf8'");
mysql_query("set character_set_client=utf8");
mysql_query("set character_set_results=utf8");

after mysql_connect(). Note that it is utf8, not utf-8.

It is also best to use utf-8 for the web page character set. UTF-8 is an international standard encoding and a trend.

If your web page encoding is gb2312, that is SET NAMES GB2312. However, the editor strongly recommends that web page encoding, MySQL data table character set, and PHPmyAdmin all use UTF-8.

Extended information:

Garbled code problem: An error occurred when entering data using PHPmyAdmin, and the input is not allowed or garbled codes appear

Solution: This is a setup issue. Please install the latest version of PHPmyAdmin or Appserv, open PHPmyAdmin, MySQL character set: UTF-8 Unicode (utf8); MySQL connection proofreading should be utf8_unicode_ci; when creating a new database, please also select utf8_unicode_ci in the finishing column.

Related recommendations: "PHP Tutorial", "mysql Tutorial"

The above is the detailed content of How to set the encoding method when php connects to mysql?. For more information, please follow other related articles on the PHP Chinese website!