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

Mon Feb 7 01:38:26 UTC 2005

(I forgot to answer the first part of your message)

On Sun, 06 Feb 2005 17:05:23 -0800, Brion Vibber <brion at pobox.com> wrote:

> 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.

What I would really like is to use "default-character-set=utf8". Any
idea why MySQL complains that

 KEY cl_sortkey(cl_to,cl_sortkey(128))

is longer than 1024 bytes?

-- 
                    /L/e/k/t/u