Ubuntu uses apt-get after installing MySQL, the server's default encoding is Latin1, the following changes the server's code to UTF8.
Coding related information:
12345678910111213 |
mysql> show variables like
‘character%‘
;
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir |
/usr/share/mysql/charsets/
|
+--------------------------+----------------------------+
|
You can see that both the Character_set_database and character_set_server codes are latin1.
Modify the MySQL encoding
Open the MySQL configuration file/etc/mysql/my.cnf
Append in [mysqld]
1 |
character- set -server=utf8 |
After saving, restart MySQL.
1 |
/etc/init .d /mysql restart |
The code is correct.
12345678910111213 |
mysql> show variables like
‘character%‘
;
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir |
/usr/share/mysql/charsets/
|
+--------------------------+----------------------------+
|
Complete.
Ubuntu Modify MySQL Default encoding method