SHOW VARIABLES LIKE '%character%';
-- 若顯示 latin1,中文存取將產生亂碼
find / -name '*.cnf' -type f 2>/dev/null | grep -E 'my-(small|medium|large|huge)'/etc/my.cnf:cp /usr/share/mysql/my-large.cnf /etc/my.cnf/etc/my.cnf:
[client]
default-character-set=utf8
[mysqld]
default-character-set=utf8
init_connect='SET NAMES utf8'
character-set-server=utf8
collation-server=utf8_general_ci
service mysql restart && mysql -e "SHOW VARIABLES LIKE '%character%';"即使服務端預設為 UTF-8,建庫/建表若不指定仍會沿用舊預設。
CREATE DATABASE mydb DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE TABLE mytbl (id INT PRIMARY KEY, name VARCHAR(100))
DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
建議直接使用 utf8mb4(支援 Emoji 與補充字元),utf8 實為 utf8mb3。
jdbc:mysql://host:3306/db?characterEncoding=utf8&useSSL=falsenew PDO("mysql:host=...;dbname=...;charset=utf8mb4", $user, $pass)charset='utf8mb4' 參數。my.cnf 後未重啟 MySQL。ALTER TABLE tbl CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;