SQL : 1267 -用于操作“=”的排序规则(utf8_general_ci，隐式)和(utf8_persian_ci，隐式)的非法混合

Question

MyBB SQL错误

MyBB经历了一个内部SQL错误，无法继续。

SQL错误：

1267 - Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_persian_ci,IMPLICIT) for operation '='

查询：

SELECT t.*
    ,t.subject AS threadsubject
    ,u.username
    ,u.usergroup
    ,u.displaygroup
    ,i.*
    ,i.NAME AS iconname
    ,t.dateline AS threaddate
    ,t.lastpost AS threadlastpost
FROM mybb_threads t
LEFT JOIN mybb_icons i ON (i.iid = t.icon)
LEFT JOIN mybb_users u ON (t.lastposter = u.username)
WHERE t.visible = '1'
    AND t.uid = '54445'
GROUP BY t.tid
ORDER BY threadlastpost DESC LIMIT 5

请与MyBB小组联系以获得技术支持。

image1

图2

Answer 1

检查罗斯史密斯二世的解决方案。他写了关于在sql语句中定义排序规则的文章。

用于操作“=”的ci (隐式)