Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.
+1 vote
732 views
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
by
 
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!
by
MySQL version: 4.1.4
Changhing to _utf8 'Q' AS matchposttype in all four places solved the problem indeed!
Thanks alot.
by
Great - FYI here's the MySQL bug: http://bugs.mysql.com/bug.php?id=15949
by
Thanks Gideon.
...