cd "C:\Program Files\MySQL\MySQL Server 5.x\bin"mysql -h 127.0.0.1 -u root -pSHOW VARIABLES LIKE 'character%';輸出關鍵行:
character_set_client utf8mb4
character_set_connection utf8mb4
character_set_database utf8mb4
character_set_results utf8mb4
character_set_server utf8mb4
character_set_system utf8
collation_server utf8mb4_general_ci
my.ini(Windows)或 /etc/my.cnf(Linux)。[mysqld] 區段新增/修改:character-set-server = utf8mb4
collation-server = utf8mb4_general_ci
[client] 區段新增:default-character-set = utf8mb4
MySQLxx 服務。systemctl restart mysqld。重新登入執行 SHOW VARIABLES LIKE 'character%';,確認 character_set_server、character_set_database 均為 utf8mb4。
character_set_server 僅影響之後新建的資料庫/表,現有物件不變。ALTER TABLE tbl_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;SET NAMES gbk 或設定終端機編碼為 UTF-8(chcp 65001)。