資料流向:`瀏覽器` → `HTTP Header/表單` → `PHP` → `PDO/mysqli` → `MySQL Server` → `資料表/欄位` → `回傳` → `PHP` → `HTTP Header/HTML` → `瀏覽器`。
任一節點編碼不匹配 (Latin1/GBK/UTF8 混雜) 即產生亂碼。
[client]
default-character-set = utf8mb4
[mysql]
default-character-set = utf8mb4
[mysqld]
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
init_connect = 'SET NAMES utf8mb4'
# 避免超級用戶 init_connect 不生效,建議在連線後再執行 SET NAMES
skip-character-set-client-handshake = OFF # 讓客戶端指定字元集
重啟 MySQL:`systemctl restart mysqld` 或 `service mysql restart`
CREATE DATABASE mydb CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE TABLE users (
id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- 既有表轉換
ALTER TABLE users CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
<?php
$dsn = "mysql:host=127.0.0.1;dbname=mydb;charset=utf8mb4";
$pdo = new PDO($dsn, 'user', 'pass', [
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
PDO::ATTR_EMULATE_PREPARES => false,
PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8mb4 COLLATE utf8mb4_unicode_ci"
]);
// 之後所有查詢自動使用 utf8mb4
; php.ini
default_charset = "UTF-8"
mbstring.internal_encoding = UTF-8
mbstring.http_input = UTF-8
mbstring.http_output = UTF-8
mbstring.language = Neutral
; 運行時 (入口檔最早處)
mb_internal_encoding('UTF-8');
mb_http_output('UTF-8');
<?php
// 於任何輸出前
header('Content-Type: text/html; charset=UTF-8');
// 或 JSON API
header('Content-Type: application/json; charset=UTF-8');
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<!-- HTML5 簡寫,等同 http-equiv Content-Type -->
</head>
$cfg['DefaultCharset'] = 'utf-8';
$cfg['RecodingEngine'] = 'iconv'; // 或 'mbstring'
$cfg['AllowAnywhereRecoding'] = true;
// libraries/string.lib.php 修改通常不再需要 (新版已修正)
-- 連線後執行
SHOW VARIABLES LIKE 'character_set%';
SHOW VARIABLES LIKE 'collation%';
-- 期望全部為 utf8mb4 / utf8mb4_unicode_ci (或 utf8mb4_general_ci)
-- 測試寫入讀取
INSERT INTO users (name) VALUES ('測試😀');
SELECT name, HEX(name) FROM users WHERE id = LAST_INSERT_ID();
-- HEX 應為 E6B8ACE8A9A6F09F9880 (UTF-8 bytes)
**全鏈路 utf8mb4** 是解決亂碼的唯一正解:MySQL Server/Database/Table/Column → 連線 DSN `charset=utf8mb4` → PHP `mb_internal_encoding` → HTTP Header `charset=UTF-8` → HTML ``。一次配置終身受益。