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

检查 Ross Smith II 的解决方案。他写了有关在SQL语句中定义整理的文章。

collations的非法混合物（utf8_unicode_ci，隐式）和（utf8_general_ci，隐式）用于操作'='