Thread:Project:Support desk/updating mediawiki 1.6.12 to 1.18

Hello again friends!

After some problems, I have updated my mediawiki properly from 1.6.12 to 1.18. I had a lot of problems with database version, and finally the solution was edit one file in order to add binary charset instead of mysql 4 (mysql4 was my error). The file is /includes/installer/mysqlinstaller, and in the line 170 have to change $existingSchema

if ( preg_match( '/^latin1/', $row->Collation ) ) { $existingSchema = 'binary';
 * 1) $existingSchema = 'mysql4';

After this, the upgrade ended properly, but now, the articles with titles that contains ñ or accents don't show properly. For example: if I had an article named "Enlaces de interés" (my mediawiki is in spanish), now its name is something like "Enlaces de inter¨#s", and this cause a lot of problems in all articles because all links to this example article are broken.

I have read that this happen because when upgrading mysql4 to mysql5, tables of database are created with charset latin1_swedish_ci, and this is true because all my tables have this charset.....I need find file/s needed in order to change this default charset to utf8

I hope have explained well

Take care, Daniel