Thread:Project:Support desk/Problem with UTF8 in 1.22 - 1.24 upgrade

Hi!

I am trying to upgrade my mediawiki 1.22 to 1.24. Overally it looks OK, but there is a problem with encoding.

1. Lets check the actual state before upgrading: a) LocalSettings.php: - "$wgDBmysql5 = false;", but change to "true" has no effect in using and upgrading - "$wgDBTableOptions = "ENGINE=InnoDB, DEFAULT CHARSET=utf8";", but no effect on changing to binary mode b) I see page and category titles in phpmyadmin without any problem, it is OK.

2. Lets try to upgrade and all looks fine, but there are errors "The category named ▒▒▒▒▒▒▒▒▒▒▒▒▒▒_▒▒▒▒▒▒▒ is not valid?!" Screenshot can be found there - https://www.dropbox.com/s/hnij1d6gc6eii98/Screenshot%202015-04-13%2004.02.27.png?dl=0

3. Upgraded DB looks fine in phpmyadmin, all page and category titles are OK. I am trying to search something in wiki and it looks fine, there are some results, but without titles of founded pages.

Overally, upgrated Wiki does not work correctly with page titles. It is really strange, because mediawiki writes titles of new pages to DB in cp1251 encoding, not utf8!

So, all data in DB are in utf8, but mediawiki works with them as cp1251. Any ideas how to fix it?

PS PHP Version 5.4.35-0+deb7u2, MySQL: 5.5.40-0+wheezy1, russial localization of mediawiki.

Have a nice day, IR