昨天新导入两张表 ，关联查询时出现 illegal mix of collations (utf8_general_ci implicit) and (utf8_unicode_ci implicit)
show variables like 'collations_%'
show variables like 'character%'
没看出什么问题
新导入表 collations 也是 utf8_general_ci
ALTER TABLE tablename CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
修复
详细原因后续再genji
阅读(758) | 评论(0) | 转发(0) |
