From a71dacada24ef2c4e2e2718471c4b5efef403221 Mon Sep 17 00:00:00 2001
From: tuqin <tuqin@tuqin.cn>
Date: 星期五, 16 十月 2026 09:19:28 +0800
Subject: [PATCH] fix(sql): 售后/问题库 SQL 追加 SET NAMES utf8mb4，修复 aftersale_reason_type 等字典/菜单中文双重编码乱码
---
sql/mysql/aftersales_ticket_text_fields.sql | 2 ++
1 files changed, 2 insertions(+), 0 deletions(-)
diff --git a/sql/mysql/aftersales_ticket_text_fields.sql b/sql/mysql/aftersales_ticket_text_fields.sql
index 091456b..07f38e8 100644
--- a/sql/mysql/aftersales_ticket_text_fields.sql
+++ b/sql/mysql/aftersales_ticket_text_fields.sql
@@ -1,6 +1,8 @@
-- =============================================
-- 鍞悗宸ュ崟锛氬鎴�/鑱旂郴浜�/鐗╂枡/鎵规 鏀逛负鏂囨湰瀛樺偍 + 鍏滃簳琛ラ綈宸ュ崟鎸夐挳鏉冮檺锛堝彲閲嶅鎵ц锛�
-- =============================================
+-- 寮哄埗杩炴帴瀛楃闆嗭紝閬垮厤涓枃琚弻閲嶇紪鐮侊紙涔辩爜锛�
+SET NAMES utf8mb4;
SET @c1 := (SELECT COUNT(*) FROM information_schema.COLUMNS
WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'after_sale_ticket' AND COLUMN_NAME = 'customer_name');
SET @ddl1 := IF(@c1 = 0,
--
Gitblit v1.9.3