(I forgot to answer the first part of your message)
On Sun, 06 Feb 2005 17:05:23 -0800, Brion Vibber <brion(a)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