mysql -u root -p
SHOW VARIABLES LIKE 'character_set_%';
若 character_set_client、connection、results、database、server 均為 latin1,即為預設編碼導致中文亂碼。
USE mydb;
ALTER DATABASE mydb CHARACTER SET utf8;
但重啟後失效,且 Debian 7.0 等新版系統常不生效。
lsb_release -a/etc/mysql/my.cnf:
[client]
default-character-set = utf8
[mysqld]
default-storage-engine = INNODB
character-set-server = utf8
collation-server = utf8_general_ci
/etc/init.d/mysql stop
/etc/init.d/mysql start
mysql -u root -p -e "SHOW VARIABLES LIKE 'character_set_%';"
所有 character_set_* 應顯示 utf8。
default-character-set = utf8 在 [mysqld] 區段,MySQL 5.5+ 會導致啟動失敗,必須改用 character-set-server。[client] 區段保留 default-character-set = utf8 即可,無需在 [mysql] 重複。/var/log/mysql/error.log 定位錯誤行。