I have MediaWiki 1.19 with MySQL 5.1.58 and php-5.3.6 installed in a SANDBOX. On the MediaWiki, I do a search with the word ''Québec'' or ''Quebec'' and I have different results...

Is there anything I can change in Apache or MySQL to fix that issue? Like adding AddDefaultCharset utf-8 to Apache (which I did and does not fix anything)..?


You need to change the collation of the database/tables, by selecting one that equates é with e that is most suitable for your needs, such as utf8_general_ci.

You should carefully select one based on your requirements, unfortunately there are a lot to choose from; http://dev.mysql.com/doc/refman//5.5/en/charset-unicode-sets.html

MySQL also offers some nice detail with Examples of the Effect of Collation.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.