RE: mysqldump + enum + default + umlaut

Hi,

Thank you for reporting this bug, I already opened the below
bug report:

http://bugs.mysql.com/bug.php?id=6165

I suggest you for to use our Bug System when reporting bugs:

http://bugs.mysql.com/


Regards,
Miguel

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

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]