How to modify mysql encoding

The method to modify the mysql encoding is: first open the mysql graphical interface SQLyog; then select the database that needs to be modified, right-click the mouse and select "Change Database"; finally set the "Database Character Set" option in the pop-up window value, you can change the encoding method of the mysql database.

Sometimes when we are developing, we need to use the mysql database. How to prevent Chinese garbled characters from appearing? Let’s share how to modify the encoding method of the mysql database. Method, I hope it will be helpful to everyone.

(1) The first step is to open the graphical interface of mysql, as shown below:

(2) The second step is to right-click the database and select "Change" Database", as shown in the figure below:

(3) In the third step, we can modify the database encoding method, as shown in the figure below:

The above is the detailed content of How to modify mysql encoding. For more information, please follow other related articles on the PHP Chinese website!