Juanma Barranquero wrote:
Anyway, setting "default-character-set=latin1" in my.ini cured all that, and I've got a working (and very nice) MediaWiki installation.
A warning: if you use mysqldump to back up, be sure to specify the --charset=latin1 option! Otherwise it will try to convert your data from Latin-1 (which is probably really UTF-8 data) into UTF-8, and then back again on import.
This conversion is actually lossy, because four code points in the Windows-1252 encoding (what it really uses for latin1) are undefined; these byte values are used in UTF-8, so they are unrecoverably corrupted.
But now I'm getting a weird error. I create a page (in this case, User:Juanma/monobook.css, but I don't think that's relevant), I delete it, and when clicking on the "deletion log" link (Special:Log/delete) or on "View or restore 1 delete edits" (Special:Undelete/User:Juanma/monobook.css) , I get the following error dump:
This is bug 1057: http://bugzilla.wikimedia.org/show_bug.cgi?id=1057
Try the patch I posted there and please report whether it solves the problem or not (I don't have a MySQL 4.1 test box set up at the moment).
I'm really puzzled by the "ltin1_swedish_ci", because my local, if anything, would be Spanish...
Ah, but MySQL AB is based in Sweden. ;)
The issue of character set configuration in MySQL is a long, sad story and unfortunately the transition to the more or less sensible support in the new 4.1 & 5.0 is going to be ugly as you have seen already.
-- brion vibber (brion @ pobox.com)