| Bug #158 | ENUM and SET types does not accept valid cp1251 character | ||
|---|---|---|---|
| Submitted: | 17 Mar 2003 5:28 | Modified: | 11 Dec 7:03 |
| Reporter: | Alexander Keremidarski | ||
| Status: | Documenting | ||
| Category: | Server | Severity: | S2 (Serious) |
| Version: | ALL | OS: | Any |
| Assigned to: | Alexander Barkov | Target Version: | |
[19 Mar 2003 4:18]
Michael Widenius
This problem is depending on how .frm format are stored and can't be fixed in the near future. For now we have just documented this issue in the manual in the bugs section.
[1 Nov 2008 5:58]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/57620 2899 Alexander Barkov 2008-11-01 Bug#158 ENUM and SET types does not accept valid cp1251 character The bug was fixed earlier. Just adding test case.
[1 Nov 2008 5:59]
Alexander Barkov
This bug was fixed in one of 4.1 releases. Added a test covering this bug into mysql-6.0.8-bugteam.
[10 Nov 2008 11:52]
Bugs System
Pushed into 6.0.8-alpha (revid:bar@mysql.com-20081101045021-hff2g35jecnpwmmr) (version source revid:bar@mysql.com-20081101045021-hff2g35jecnpwmmr) (pib:5)
[10 Nov 2008 18:51]
Paul DuBois
No changelog entry needed.
[29 Oct 14:17]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/88586
[9 Nov 11:58]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/89764
[20 Nov 13:58]
Bugs System
Pushed into 6.0.14-alpha (revid:kostja@sun.com-20091120124947-yi6h2jbgw0kbciwm) (version source revid:epotemkin@mysql.com-20091109132131-ad1gk2d2tn9o5i3l) (merge vers: 6.0.14-alpha) (pib:13)
[11 Dec 7:03]
Bugs System
Pushed into 5.6.0-beta (revid:alik@sun.com-20091211055628-ltr7fero363uev7r) (version source revid:alik@sun.com-20091211055453-717czhtezc74u8db) (merge vers: 5.6.0-beta) (pib:13)
Description: In cp1251 charset there is valid Cyrillic character with ASCII code 255 'ÿ' - small capital 'ya' When it is used in ENUM or SET types MySQL split's up string at the position of 'ÿ' and instead of original string creates one empty string at the position of 'ÿ' This is serious problem for cp1251 users as this renders ENUM and SET type unusable for Cyrillic values. How to repeat: CREATE TABLE enum255 ( e1 enum('ÿáúëêà'), e2 enum('ìëÿêî') ) TYPE=MyISAM; SHOW CREATE TABLE enum255; CREATE TABLE enum255 ( enum('','áúëêà') default NULL, e2 enum('ìë','êî') default NULL ) TYPE=MyISAM;