How to fix search and database collation?

Question

Error 1267: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'UNION'

My database collation is utf8_general_ci, still I am getting this whenever I am trying to use the search function.

Answer 1

Can you tell me which version of MySQL you are using? There are some bugs filed on the MySQL site relating to this, so it could be a MySQL issue.

Apart from that, you might be able to solve it by modifying some of the SQL inside the qa_db_search_posts_selectspec(...) function in qa-db-selects.php. Please try making the change below in the four places where it matches:

'Q' AS matchposttype

... to ...

_utf8 'Q' AS matchposttype

Please let me know if this solves the problem!

Comments

MySQL version: 4.1.4
Changhing to _utf8 'Q' AS matchposttype in all four places solved the problem indeed!
Thanks alot.

---

Great - FYI here's the MySQL bug: http://bugs.mysql.com/bug.php?id=15949

---

Thanks Gideon.