After xampp is installed, how to configure the my. ini file and ask for high scores. When I first came into contact with php, I found that my. ini was missing a lot. now I want to modify the default encoding. The default encoding is as follows: mysql & gt; showvariableslikechar %; + ---------------------------- + -------------------------------- + | how to configure the my. ini file when Var is installed.
When I first came into contact with php, I found that my. ini was missing a lot. now I want to modify the default encoding. The default encoding is as follows:
Mysql> show variables like 'char % ';
+ -------------------------- + ---------------------------------- +
| Variable_name | Value |
+ -------------------------- + ---------------------------------- +
| Character_set_client | gbk |
| Character_set_connection | gbk |
| Character_set_database | latin1 |
| Character_set_filesystem | binary |
| Character_set_results | gbk |
| Character_set_server | latin1 |
| Character_set_system | utf8 |
| Character_sets_dir | C: \ xampp \ mysql \ share \ charsets \ |
+ -------------------------- + ---------------------------------- +
8 rows in set (0.00 sec)
I want to change the default values of gbk and latin1 to utf8.
------ Solution --------------------
Add the following content to the mysqld quota group:
Default-character-set = utf8;
Or you can set names utf8 each time.
------ Solution --------------------
Default_character_set = utf8