John Blumel wrote:
I recently dumped (well, someone else dumped it) the data from a MediaWiki database stored in a MySQL v3.23.58 server and imported it into a v4.0.21 server.
I noticed on the new instance of the wiki, running on MySQL v4.0.21, that there were some pages where the text wasn't displaying properly and on Editing the page, the 'bad' data was replaced with a number of question marks. Without saving the Edit, I noticed that characters in the database were garbled (I temporarily do not have access to the original site so I can't verify the exact original data but it was served correctly there just before that server was taken off-line and the dump produced.) and that the "garbling" originated in the dump file (probably created in the dump process).
Using the same encoding?
Latin-1 or UTF-8 wiki?
-- brion vibber (brion @ pobox.com)