Home > Database > Mysql Tutorial > body text

How to modify mysql encoding

清浅
Release: 2020-09-15 11:59:29
Original
10078 people have browsed it

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.

How to modify mysql encoding

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:

How to modify mysql encoding

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

How to modify mysql encoding

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

Image 051.png

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!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template