Last modified: 2013-04-11 13:35:18 UTC
Created attachment 10829 [details]
page table from a early install
I installed mediawiki when it was in its early stages (1.5? it was the beginning of 2006) on a windows server. It was then upgraded to 1.15, then it was transferred to a linux server, and upgraded to 1.16.
Now I upgraded to 1.19, but I'm accented letters in article names are presented with weird characters, tipically the characters you see when a utf8-encoded text is interpreted as a latin1 one or viceversa.
Looking for a solution, I found this thread:
but it didn't help me to solve the issue.
Apparently the problem comes from the fact that my db has conserved some early version characteristic. I'm attacching a page table structure, where you can see varchar field, while I'm intending that mediawiki supposes to have varbinary ones.
The update script should check this case and manage it.
We found this problem while updating from/to 1.17/1.18 versions (I can't remember the exact version numbers).
How did you solve it?
Looking for a workaround, I upgraded to 1.17.4, but I got the same issue.
Paolo: Does bug 32207 comment 3 help?
Andre, I could realize that my db install still had latin1 encoding, I had to convert it to utf8, I don't remember precisely how, but I solved it.
*** Bug 29731 has been marked as a duplicate of this bug. ***