IIWAB Mysql SQL问题 Illegal mix of collations for operation UNION 排查解决 - IIWAB

Mysql SQL问题 Illegal mix of collations for operation UNION 排查解决

IIWAB 9月前 ⋅ 253 阅读

表字段的字符集的问题

select * from information_schema.columns  where  table_schema = 'xxx' and data_type = 'varchar' and (collation_name != 'utf8mb4_general_ci' or character_set_name != 'utf8mb4');


select  DISTINCT character_set_name from information_schema.columns  where  table_schema = 'xxx';


select DISTINCT table_collation from information_schema.tables  where  table_schema = 'xxx';


select * from information_schema.tables  where  table_schema = 'xxx';

排查没问题。

尝试不同的驱动。 java mysql驱动， 8.0.25没问题， 8.0.27有问题


注意：本文归作者所有，未经作者允许，不得转载

阅读全部

全部评论: 0 条

    我有话说: