Bug #158 ENUM and SET types does not accept valid cp1251 character
Submitted: 17 Mar 2003 4:28 Modified: 6 Mar 2010 18:15
Reporter: Alexander Keremidarski Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:ALL OS:Any
Assigned to: Alexander Barkov CPU Architecture:Any

[17 Mar 2003 4:28] Alexander Keremidarski
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;
[19 Mar 2003 3: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 4: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 4: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 10: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 17:51] Paul DuBois
No changelog entry needed.
[29 Oct 2009 13: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 2009 10: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 2009 12: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 2009 6: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)
[11 Dec 2009 19:24] Paul DuBois
No changelog entry needed.
[6 Mar 2010 10:53] Bugs System
Pushed into 5.5.3-m3 (revid:alik@sun.com-20100306103849-hha31z2enhh7jwt3) (version source revid:vvaintroub@mysql.com-20091211201717-03qf8ckwiw0np80p) (merge vers: 5.6.0-beta) (pib:16)