research_donation_collation_unicode_ci.sql 879 B

12345678910
  1. -- 科研捐赠相关表排序规则与 biz_sample_reception 等表对齐(utf8mb4_unicode_ci)
  2. -- 修复样本接收待办查询:Illegal mix of collations (utf8mb4_general_ci) and (utf8mb4_unicode_ci)
  3. -- 在已有库执行本脚本一次即可
  4. ALTER TABLE `biz_research_donation` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  5. ALTER TABLE `biz_research_donation_audit` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  6. ALTER TABLE `biz_research_donation_collection` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  7. ALTER TABLE `biz_research_donation_party` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  8. ALTER TABLE `biz_research_donation_sample` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  9. ALTER TABLE `biz_research_donation_sample_transport` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;