首页 » 数据库 » Mysql » 正文

Linux查看并修改mysql字符集

1. 查看字符集:
mysql> show variables like ‘collation_%’;
+———————-+——————-+
| Variable_name | Value |
+———————-+——————-+
| collation_connection | utf8_general_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
+———————-+——————-+
3 rows in set (0.00 sec)

mysql> show variables like ‘character_set_%’;
+————————–+———————————+
| 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 | /data/app/mysql/share/charsets/ |
+————————–+———————————+
8 rows in set (0.00 sec)


2.在[client]和[mysqld]下面添加
[client]
default-character-set=utf8
[mysqld]
character-set-server=utf8


3. 重启mysql服务,再次查看字符集
mysql> show variables like ‘collation_%’;
———————+—————–+
| Variable_name | Value |
+———————-+—————–+
| collation_connection | utf8_general_ci |
| collation_database | utf8_general_ci |
| collation_server | utf8_general_ci |
+———————-+—————–+
3 rows in set (0.00 sec)

mysql> show variables like ‘character_set_%’;
+————————–+———————————+
| 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 | /data/app/mysql/share/charsets/ |
+————————–+———————————+
8 rows in set (0.00 sec)

发表评论

*