登录 mysql,通过 show variables like "%character%"; show variables like "%collation%";
命令来查看数据库的编码:
mysql> show variables like "%character%"; show variables like "%collation%";
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.05 sec)
+----------------------+-------------------+
| Variable_name | Value |
+----------------------+-------------------+
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
+----------------------+-------------------+
默认的数据库编码方式基本都设置成了 latin1 的编码方式,我们需要将其修改成 utf8 的编码格式:
- 找到 mysql 的主配置文件,然后将其复制到 /etc 目录下
cp /usr/share/doc/my-large.cnf /etc/my.cnf
- 修改 my.cnf 配置文件 (1) 在 [client] 下增加
default-character-set=utf8
(2) 在 [mysqld] 下增加
default-character-set=utf8
default-collation=utf8_unicode_ci
init_connect='SET collation_connection = utf8_unicode_ci'
init_connect='SET NAMES utf8'
(3) 重新启动 mysqld 服务 service mysqld restart