要不这么看,字符集和排序规则实际是绑定的
SELECT CCSA.character_set_name AS character_set_name, CCSA.collation_name AS collation_name
FROM information_schema.tables IST
JOIN information_schema.collation_character_set_applicability CCSA ON IST.table_collation = CCSA.collation_name
WHERE IST.table_schema = ‘automaildb’ AND IST.table_name LIKE ‘bi_email_excel_config%’;