Problems with ENUM in cp1251

Hi. I have a problem with ENUM field type. I try to create table with
field type ENUM, the elements of ENUM is russian words in codepage cp1251.
After creating table i have got table with incorect structure.
Exaple with bug:
mysql> create table a(
-> id int(11) primary key not null,
-> b ENUM('ÈÕÄÁ=D1', 'ÓÔÒÏÊÎÁÑ', '=
ÓÒÅÄÎÁ=D1', 'ÐÏÌÎÁÑ')
-> );
Query OK, 0 rows affected (0.01 sec)

mysql> describe a;

+-------+-------------------------------------------------+- -----+-----+---=
------+-------+
| Field | Type | Null | Key
| Default | Extra |

+-------+-------------------------------------------------+- -----+-----+---=
------+-------+
| | int(11) | | PRI
| 0 | |
| e=9E | enum('','','ÓÔÒÏÊÎ=C1','','ÓÒÅÄÎÁ',' '=
,'ÐÏÌÎ=C1','') | YES | |
NULL | |

+-------+-------------------------------------------------+- -----+-----+---=
------+-------+
2 rows in set (0.00 sec)

Worked if we try to create without char '=D1'
mysql> create table a(
-> id int(11) primary key not null,
-> b ENUM('ÈÕÄÁ', 'ÓÔÒÏÊÎ=C1', 'ÓÒ=
ÅÄÎÁ', 'ÐÏÌÎ=C1')
-> );
Query OK, 0 rows affected (0.00 sec)

mysql> describe a;

+-------+-----------------------------------------+------+-- ---+---------+-=
------+
| Field | Type | Null | Key |
Default | Extra |

+-------+-----------------------------------------+------+-- ---+---------+-=
------+
| id | int(11) | | PRI | 0
| |
| b | enum('ÈÕÄÁ','ÓÔÒÏÊÎ=C1','ÓÒÅÄ=CE =
=C1','ÐÏÌÎ=C1') | YES | | NULL
| |

+-------+-----------------------------------------+------+-- ---+---------+-=
------+
2 rows in set (0.00 sec)
With KOI8-R it ok.
Bigildeev Artem.

------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13977@lists.mysql.com
To unsubscribe, e-mail

Re: Problems with ENUM in cp1251

Privet Artem,

âÉÇÉÌØÄÅÅ× áÒÔÅÍ wrote:
> Hi. I have a problem with ENUM field type. I try to create table with
> field type ENUM, the elements of ENUM is russian words in codepage cp1251.

Thank you for your bug report. You confirmed my tests about previous report I got
recently about the same problem.

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

Best regards

--
MySQL Conference and Expo 2003 http://www.mysql.com/events/uc2003/index.html
For technical support contracts, visit https://order.mysql.com/?ref=msal
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Alexander Keremidarski
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Sofia, Bulgaria
<___/ www.mysql.com




------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13978@lists.mysql.com
To unsubscribe, e-mail