charset/mysqldump bug?
Posted by: kennylucius
Date: January 28, 2007 08:52PM

I want to document a problem on Ver 14.12 Distrib 5.0.27, for apple-darwin8.5.1 (i686). The following dump command:

$ mysqldump --hex-blob ... -rdump.sql database

produces a file with an unknown character set. Using BBEdit, I have opened the file with UTF-8 and several Latin charsets, and none of them are right. Using this command:

$ mysqldump --default-character-set=latin1 --skip-set-charset --hex-blob ... -rdump.sql database

I am able to produce a valid UTF8 file that can be imported elsewhere with this command:

$ mysql --default-character-set=utf8 ... database < dump.sql

Why is mysqldump producing UTF8 only when set to Latin1? Setting it to UTF-8, which is the default, produced something I was unable to identify.

I am using the default Max installation.

Options: ReplyQuote


Subject
Views
Written By
Posted
charset/mysqldump bug?
5701
January 28, 2007 08:52PM
3604
February 13, 2007 06:56AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.