Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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...(wich I did and does not fix anything)....

Thank's !

share|improve this question

1 Answer 1

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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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