[Mediawiki-l] "Illegal mix of collations" on a 1.4beta6 installation on Windows

Brion Vibber brion at pobox.com
Mon Feb 7 01:05:23 UTC 2005


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)
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 253 bytes
Desc: OpenPGP digital signature
Url : http://lists.wikimedia.org/pipermail/mediawiki-l/attachments/20050206/529c1de3/attachment.pgp 


More information about the MediaWiki-l mailing list