Ubuntu 透過 apt 安裝 MySQL 後,主設定檔位於 /etc/mysql/my.cnf。若找不到,可執行:
sudo find / -name '*.cnf' -type f 2>/dev/null
使用編輯器(如 vim、nano)開啟 /etc/mysql/my.cnf,在對應區段新增 character-set-server=utf8 與 collation-server=utf8_general_ci:
[mysqld]
character-set-server=utf8
collation-server=utf8_general_ci
init_connect='SET NAMES utf8'
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
注意:MySQL 5.5+ 建議使用
utf8mb4以完整支援 Emoji 與補充字元,設定值改為utf8mb4及utf8mb4_general_ci。
sudo service mysql restart
# 或 systemd 系統
sudo systemctl restart mysql
mysql -u root -p -e "SHOW VARIABLES LIKE 'character_set%'; SHOW VARIABLES LIKE 'collation%';"
預期輸出關鍵變數皆為 utf8(或 utf8mb4):
+--------------------------+-----------------+
| 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/ |
+--------------------------+-----------------+
ALTER DATABASE db_name CHARACTER SET utf8 COLLATE utf8_general_ci;ALTER TABLE tbl_name CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;