How to set the default encoding format of data table in mysql

Mysql method to set the default encoding format of the data table: 1. Open the my.ini configuration file; 2. Add the configuration [default-character-set=utf8]; 3. Restart the mysql service.

Find the installation directory of mysql

(Recommended tutorial: mysql video tutorial)

# There is my-default.ini in the

## directory. I modified it to my.ini here. Open the configuration and add the following content:

Add Content:

character-set-server=utf8
[client]
default-character-set=utf8

Then restart the Mysql service.

Related recommendations:

mysql tutorial

The above is the detailed content of How to set the default encoding format of data table in mysql. For more information, please follow other related articles on the PHP Chinese website!