首先更改mysql的数据编码,修改mysql的配置文件: /etc/mysql/my.cnf 添加:
- [client]
- default-character-set = utf8mb4
- [mysql]
- default-character-set = utf8mb4
- [mysqld]
- character-set-client-handshake = FALSE
- character-set-server = utf8mb4
- collation-server = utf8mb4_unicode_ci
重启mysql:输入命令
SHOW VARIABLES WHERE Variable_name LIKE 'character\_set\_%' OR Variable_name LIKE 'collation%';
- --------------------------+----------------------------+
- | Variable_name | Value |
- +--------------------------+----------------------------+
- | character_set_client | utf8mb4 |
- | character_set_connection | utf8mb4 |
- | character_set_database | utf8mb4 |
- | character_set_filesystem | binary |
- | character_set_results | utf8mb4 |
- | character_set_server | utf8mb4 |
- | character_set_system | utf8 |
- | character_sets_dir | /usr/share/mysql/charsets/ |
- | collation_connection | utf8mb4_unicode_ci |
- | collation_database | utf8mb4_unicode_ci |
- | collation_server | utf8mb4_unicode_ci |
- +--------------------------+----------------------------+
第一步:给数据库,数据表,字段添加 utf8mb4编码
地址来源:http://zhidao.baidu.com/question/264009281026565765.html?fr=iks&word=mysql+%C3%FB%D7%D6%B4%F8moji%CD%BC%C6%AC%2C%D4%F5%C3%B4%B4%E6%B5%BDmysql%C0%EF%2C%D7%D6%B7%FB%B1%E0%C2%EB&ie=gbk