Thread:Project:Support desk/UTF8 Problem with update from 1.16 to 1.17/reply (5)

Hello,

I managed to solve the problem. It was caused by the coding of datebase. My database tables were coded in UTF-8, but if you normally install the new Mediawiki 1.18, it is coded in "binary".

My steps were: In phpmyadmin - ALTER TABLE page CONVERT TO CHARACTER SET latin1 COLLATE latin1_bin - as this sollution I found somewhere in internet. The same I made to all tables which contain text fields and all worked correctly.

Only than I looked to new installation and I made second conversion "ALTER TABLE page CONVERT TO CHARACTER SET binary" and all is working correctly still.

Only the table "searchindex" cannot be converted to binary.