On 24/02/07, Fernando M. M. list@fernandomarcelo.com wrote:
I'm trying to move mediawiki to another server. Everything was fine until i discovered that all special characters on wiki_page table were messed up. I really don't know what is going on because on the other tables all those special characters like ã or ó are ok.
When exporting, ensure that the character set is kept as latin1. When importing, ensure that the character set is kept as latin1. MySQL will "helpfully" try to convert, and this will usually break things.
Rob Church