31 lines
2.5 KiB
SQL
31 lines
2.5 KiB
SQL
-- =====================================================================
|
||
-- 修复：campus_notice 库字符集 latin1 → utf8mb4（2026-09-09 接口检测发现）
|
||
-- 现象：所有含中文的写入（notice Create/SaveDraft/Forward/Edit、审批人姓名、
|
||
-- 审批意见等）报 Incorrect string value → 全局兜底为「内部服务错误」。
|
||
-- 根因：建库未指定字符集（latin1_swedish_ci），Hibernate ddl-auto=update
|
||
-- 建表继承库默认，全部 14 张表均为 latin1。
|
||
-- 修复：在线转换（存量数据仅 ASCII，转换无损）；应用无需重启。
|
||
-- DBA 建议：生产建库统一 utf8mb4_general_ci；新表继承库默认后即为 utf8mb4。
|
||
-- =====================================================================
|
||
|
||
ALTER DATABASE campus_notice CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci;
|
||
|
||
ALTER TABLE campus_notice.notice CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
|
||
ALTER TABLE campus_notice.notice_read CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
|
||
ALTER TABLE campus_notice.notice_receiver CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
|
||
ALTER TABLE campus_notice.notice_push_scope CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
|
||
ALTER TABLE campus_notice.notice_approval CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
|
||
ALTER TABLE campus_notice.notice_approver_memory CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
|
||
ALTER TABLE campus_notice.sys_dict CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
|
||
ALTER TABLE campus_notice.template_type CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
|
||
ALTER TABLE campus_notice.notice_template CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
|
||
ALTER TABLE campus_notice.up_file CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
|
||
ALTER TABLE campus_notice.contacts_group CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
|
||
ALTER TABLE campus_notice.contacts_group_user CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
|
||
ALTER TABLE campus_notice.sms_module CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
|
||
ALTER TABLE campus_notice.sms_school_config CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
|
||
|
||
-- 核查（预期全部 utf8mb4）：
|
||
-- SELECT table_name, table_collation FROM information_schema.TABLES
|
||
-- WHERE table_schema='campus_notice' ORDER BY table_name;
|