zkxw/docs/sql/migrations/2026-10-14-sample-freight-collation-unicode.sql

-- 样本运费表校对规则对齐存量库 utf8mb4_unicode_ci
-- 背景：2026-10-07 建表仅写 DEFAULT CHARSET=utf8mb4，MySQL 5.7 默认落成
-- utf8mb4_general_ci；与协议/样本等 unicode_ci 表 JOIN 会报 1267
-- Illegal mix of collations，移动端 /mini/market/*/freights 返回 503。

SET NAMES utf8mb4;

ALTER TABLE `biz_sample_freight`
  CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

ALTER TABLE `biz_sample_freight_item`
  CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;