資料流向:**Client → Connection → Server → Database → Table → Column**。**任何一環編碼不一致**即產生亂碼。
| 層級 | 設定項目 | 建議值 | 檢查指令 |
|---|---|---|---|
| 伺服器 | character-set-server | utf8mb4 | SHOW VARIABLES LIKE 'character_set_server'; |
| 資料庫 | DEFAULT CHARACTER SET | utf8mb4 | SHOW CREATE DATABASE db_name; |
| 資料表 | DEFAULT CHARSET | utf8mb4 | SHOW CREATE TABLE tbl_name; |
| 欄位 | CHARACTER SET | utf8mb4 | SHOW FULL COLUMNS FROM tbl_name; |
| 連線 | SET NAMES / character_set_connection | utf8mb4 | SHOW VARIABLES LIKE 'character_set_connection'; |
[mysqld]
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
init_connect = 'SET NAMES utf8mb4' # 自動設定連線編碼
[client]
default-character-set = utf8mb4
[mysql]
default-character-set = utf8mb4
CREATE DATABASE mydb
DEFAULT CHARACTER SET utf8mb4
DEFAULT COLLATE utf8mb4_unicode_ci;
CREATE TABLE users (
id INT PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
$pdo = new PDO(
"mysql:host=localhost;dbname=mydb;charset=utf8mb4",
$user, $pass,
[PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]
);
// 或 mysqli
$mysqli->set_charset('utf8mb4');
**注意**:舊版 PHP/MySQL 驅動需執行 SET NAMES utf8mb4 或 SET CHARACTER SET utf8mb4。
<meta charset="UTF-8">
character_set_server = utf8mb4SET NAMES utf8mb4<meta charset="UTF-8">Content-Type: text/html; charset=utf-8**「全鏈路 utf8mb4」**是徹底解決 MySQL 亂碼的唯一正解。從 my.cnf、建表語句、連線程式碼、HTML 模板到編輯器編碼,**端到端統一**,亂碼問題將徹底消失。