mysqldump + enum + default + umlaut

am 16.09.2004 14:14:26 von Andreas Pardeike

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=20
this.
It seems that there is no easy way to edit such a dump without=20
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@m.gmane.org

Re: mysqldump + enum + default + umlaut

am 19.10.2004 21:42:05 von miguel solorzano

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@m.gmane.org

RE: mysqldump + enum + default + umlaut

am 19.10.2004 21:52:03 von miguel solorzano

Re[2]: mysqldump + enum + default + umlaut

am 21.10.2004 10:46:28 von Juri Shimon

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@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@m.gmane.org

Re: mysqldump + enum + default + umlaut

am 21.10.2004 11:12:37 von miguel solorzano

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@m.gmane.org