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