Java 源文件編碼 → 編譯字節碼 → JVM 運行時字符串 (UTF-16) → JDBC 驅動編碼 → 網絡傳輸 → MySQL 服務端編碼 → 表/列/連接編碼 → 存儲。任一環節不一致即產生亂碼。
-- 建庫
CREATE DATABASE mydb CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- 建表
CREATE TABLE users (
name VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- 修改現有表
ALTER TABLE users CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
關鍵:使用 utf8mb4 而非 utf8(MySQL 的 utf8 只支持 3 字節,無法存儲 Emoji、部分生僻字)。
// JDBC URL (MySQL Connector/J 5.1+)
jdbc:mysql://localhost:3306/mydb?useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai&zeroDateTimeBehavior=convertToNull
// 8.0+ 驅動默認 UTF-8,仍建議顯式聲明
jdbc:mysql://localhost:3306/mydb?characterEncoding=utf8mb4
SET NAMES utf8mb4
SET CHARACTER_SET_CLIENT=utf8mb4
SET CHARACTER_SET_CONNECTION=utf8mb4
SET CHARACTER_SET_RESULTS=utf8mb4
// web.xml (Servlet 容器)
encodingFilter
org.springframework.web.filter.CharacterEncodingFilter
encoding
UTF-8
forceEncoding
true
encodingFilter
/*
Spring Boot 2.1+ 默認已開啟 server.servlet.encoding.enabled=true、force=true、charset=UTF-8。
<%@ page pageEncoding="UTF-8" contentType="text/html;charset=UTF-8" %>
<meta charset="UTF-8">
INSERT INTO users(name) VALUES('測試😀')。SELECT HEX(name), CHAR_LENGTH(name), CHARACTER_LENGTH(name) FROM users。中文每字 3 字節,Emoji 4 字節。System.out.println(Arrays.toString(name.getBytes(StandardCharsets.UTF_8)))。Content-Type: application/json;charset=UTF-8。new String(bytes, "ISO-8859-1") 強制轉碼掩蓋症狀,實則雙重錯誤湊巧顯示正常,遷移環境即崩。serverTimezone 導致時區亂碼(時間類型)。[mysqld]
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
init_connect = 'SET NAMES utf8mb4'
skip-character-set-client-handshake = true # 強制忽略客戶端聲明編碼