On Sat, 24 Feb 2007 17:34:23 +0000, "Rob Church" robchur@gmail.com wrote:
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 _______________________________________________ MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Hello,
Here is what i'm trying. I go to phpmyadmin on the old server. Click on export and save it as a .zip package on my computer. Them i go to phpmyadmin on the new server. Click on import, select 'latin1', select the .zip file on my computer and import it. That's not working.
On the old server looking directly into the database i see
Página_principal
On the wiki_page table. When i view at mediawiki i see Página principal (which means Main Page and that's correct).
But when i view into the database at the new server i see
Página_principal
And on the wiki i see Página principal