我的系統是Ubuntu 16.04,
mysql是5.7,
試過很多方法,沒什麼用,最後還是要修改檔案...最不喜歡的操作
隻需要修改一個檔案即可,
指令行輸入
find / -name my.cnf
找到我們需要修改的檔案my.cnf
我這裡看到有不同位址的3個,就不列出了
我個人選擇了/ect/mysql/my.cnf這個檔案
vi進去修改,直接将需要的參數
[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
init_connect='SET NAMES utf8mb4'
添加到末尾
ZZ儲存退出,重新開機mysql
然後進入mysql,輸入以下指令檢視
SHOW VARIABLES WHERE Variable_name LIKE 'character\_set\_%' OR Variable_name LIKE 'collation%';
如出現以下資訊,即可儲存emoji字元
+--------------------------+--------------------+
| 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 |
| collation_connection | utf8mb4_unicode_ci |
| collation_database | utf8mb4_unicode_ci |
| collation_server | utf8mb4_unicode_ci |
+--------------------------+--------------------+