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)