Shulou(Shulou.com)06/01 Report--

This article mainly discusses how to solve the problem of phpmyadmin garbled. There is a certain reference value, friends in need can refer to, follow the editor to see the solution.

Phpmyadmin database garbled?

1. Check the server code in phpMyAdmin

After logging in to phpMyAdmin, you can see the server code on the home page.

From the figure, we can see that the MySQL server is encoded as UTF-8 Unicode (utf8).

Specify the character set when creating the database in phpMyAdmin

When we talked about the priority of the character set, we said that the priority of the database character set is higher than that of the server. The process of creating a database and specifying a character set in phpMyAdmin is shown below:

The name of the database in the figure is baidusql, and the character set is gbk_chinese_ci, or gbk.

If you need to modify the character set of the database, you can select the database, then click the "Action" option, find the option you need in the "organize" drop-down list, and then click the "execute" button.

Create a table in phpMyAdmin and specify the character set

When creating a table, fill in the table name and field name first, and click the execute button

In the creation page, collation defaults to the empty option. If not selected, the character set of the database is inherited by default.

If you have special needs, you can specify it yourself, otherwise it is recommended to keep the default value.

After entering the data, the Chinese display is normal!

The above is the solution to the phpmyadmin garbled problem, after reading it, do you have anything to gain? If you want to know more about it, you are welcome to follow the industry information!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.