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

Thanks for the information.

I realized that dealing with only one table (page) wasn't enough. Category titles and user pages with umlaute were broken too. So I decided to run "ALTER TABLE tablename CONVERT TO CHARACTER SET latin1 COLLATE latin1_bin" on all tables. Then I exported and imported.

After that I ran "ALTER TABLE tablename CONVERT TO CHARACTER SET binary" on all tables. About 5 tables (among them "searchindex") didn't accept the character set binary and showed to have latin1_swedish_ci (I don't know why!?). Anyway, I took those 5 tables and assigned them binary via the operation button -> collation, which worked.

I hope this is all okay?

Wiki looks fine now in all places :)