On 07/06/06, Brion Vibber <brion(a)pobox.com> wrote:
Ben Bullock wrote:
When I do
mysqldump --user=XXXX --host=YYYY.db -ceqp
--default-character-set=utf8 --hex-blob --set-charset=utf8 ZZZZ >
ZZZZ.sql
MySQL 4.0.x doesn't support UTF-8, and thinks that your data is in latin-1 or
whatever its server-wide charset setting is (though it's really UTF-8). Remove
the --set-charset option to avoid false data conversion.
Thanks.
Unfortunately, when I try doing this and then reloading the SQL into a
database on my home machine using
mysql -u root -p --force --default-character-set=utf8 < ZZZZ.sql
the utf8 is not recognized. This is on my home machine using MySQL
mysql Ver 14.12 Distrib 5.0.18, for redhat-linux-gnu (i386) using readline 5.0
It's the same problem with or without the options about utf8 on the save line.
Any ideas?