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

Thank you so much Jirka!

I spent 2 hours searching for a solution for the umlaut problem - until I found this thread.

I successfully updated my MediaWiki from 1.16.2 to 1.19.1.

A short explanation for those who might be still confused about what to do:
 * Navigate to the old database in phpMyAdmin
 * Click on the SQL button (between structure and search)
 * Enter the following and press OK: ALTER TABLE page CONVERT TO CHARACTER SET latin1 COLLATE latin1_bin
 * Export the old database as gzip file
 * Create a new database and import the gzip file
 * It's necessary to update the old database. Navigate to yoursite.com/mediawiki/mw-config/index.php and follow the instructions.

These steps worked for me.

It was sufficient to only alter the page table - not more. The umlaute are shown correctly.

Is it necessary to turn the page table (of the new database) to binary??

It didn't change anything.

But here is how to do it:
 * Navigate to the new database in phpMyAdmin
 * Click on the SQL button
 * Enter the following and press OK: ALTER TABLE page CONVERT TO CHARACTER SET binary