Database php Chinese characters garbled

The problem of using UTF-8 encoding for MYSQL database

1. Use phpmyadmin to create the database and data table

Create the database When creating a data table, please set "Organization" to: "utf8_general_ci" or execute the statement:

When creating a data table: If the field stores Chinese, you need to set "Organization" to: " utf8_general_ci",

If this field stores English or numbers, the default is fine.

Corresponding SQL statement, for example:

2. Use PHP to read and write the database

After connecting to the database:

Add two lines:

Then you can read and write the MYSQL database normally.

The environment made using appserv-win32-2.5.10 uses the default utf8 encoding when installing this package.

When writing the database connection file, write:

Then when making the page, pay attention to this sentence:

In this way, regardless of the Chinese input into the database, or the page display, It's all normal.

In the DW CS4 version, the utf8 page is also generated by default.

Similarly, if you first write the database connection file as: mysql_query("SET NAMES 'GBK'");

Then the page will also change accordingly:

For more PHP-related knowledge, please visit PHP中文网!

The above is the detailed content of Database php Chinese characters garbled. For more information, please follow other related articles on the PHP Chinese website!