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/bugs?unsub=3Dgcdmb-bugs [at] m.gmane.org

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/bugs?unsub=gcdmb-bugs [at] m.gmane.org

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/bugs?unsub=gcdmb-bugs [at] m.gmane.org

Hello miguel,

Tuesday, October 19, 2004, 10:52:03 PM, you wrote:

ms> Hi,

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

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

> How to repeat:
> create table t0 (id int not null auto_increment primary key,
> foo enum('a','b','o') default 'o');

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

Is this a same bug?

--
Best regards,
Juri mailto:juri [at] mmf.dp.ua


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql [at] m.gmane.org

Juri Shimon wrote:

Hi,

> Hello miguel,
>
> Tuesday, October 19, 2004, 10:52:03 PM, you wrote:
>
> ms> Hi,
>
> ms> Thank you for reporting this bug, I already opened the below
> ms> bug report:
>
> ms> http://bugs.mysql.com/bug.php?id=6165
>
>
>>How to repeat:
>>create table t0 (id int not null auto_increment primary key,
>>foo enum('a','b','o') default 'o');
>
>
> http://bugs.mysql.com/bug.php?id=5728
>
> Is this a same bug?
>
According with the user who reported the bug yes. I did the status changes
according his answer.

Regards,
Miguel


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql [at] m.gmane.org