-- =====================================================================
-- 修复：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;