mysqldump + enum + default + umlaut

Hi,

I am trying to back up a database that has a field definition like i.e.

foo enum('a','b','ö') default 'ö'

and mysqldump does not correctly encode the umlauts in it. Depending on
the charset I set I get either lots of '?' instead of the umlauts or if
I specify utf8 for the charset I will get the correct umlauts in the
enum values but not in the default value!

I am using 4.1.2-alpha-standard and I couldn't see a bug fix for this
in the recent version history.

I already lost a whole day recovering a deleted database because of 
this.
It seems that there is no easy way to edit such a dump without 
destroying
the encoding and I ended up with a database that had many fields empty
because the database values didn't match the enum definition.

Any help appreciated,
Andreas Pardeike

-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]