Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.
+1 vote
in Q2A Core by
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.

1 Answer

+1 vote
Best answer
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!
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.