Bug #27570 | Russian lowcase 'ya' (cp1251) breaks SET or ENUM type | ||
---|---|---|---|
Submitted: | 1 Apr 2007 10:44 | Modified: | 30 Sep 2007 10:27 |
Reporter: | Alexander Bechkov | Email Updates: | |
Status: | No Feedback | Impact on me: | |
Category: | MySQL Server: Charsets | Severity: | S2 (Serious) |
Version: | 3-5, 5.0.44 | OS: | Linux |
Assigned to: | CPU Architecture: | Any |
[1 Apr 2007 10:44]
Alexander Bechkov
[1 Apr 2007 16:35]
Valeriy Kravchuk
Thank you for a problem report. Please, try to repeat with a newer version, 5.0.37, and inform about the results. In case of the same problem, please, send the results of SHOW VARIABLES LIKE 'cha%' from the same environment.
[1 May 2007 23:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
[2 May 2007 7:24]
Valeriy Kravchuk
Feedback is still needed.
[23 May 2007 11:48]
Valeriy Kravchuk
Please, check with a newer version, 5.0.41.
[23 Jun 2007 23:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
[17 Aug 2007 17:05]
Alexander Bechkov
Using default utf8 all is OK, but when cp1251 database created(with same connection-collation charset) lowcase 'ya' breaks SET or ENUM type Old versions of mysql has the same "feature": CREATE TABLE `testtbl2` ( `section` enum('a','b','аяа','e') NOT NULL default 'a'); Query OK, 0 rows affected (0.00 sec) mysql> show fields from testtbl2; +---------+---------------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+---------------------------+------+-----+---------+-------+ | section | enum('a','b','а','а','e') | | | a | | +---------+---------------------------+------+-----+---------+-------+ 1 row in set (0.00 sec) mysql> show variables like 'character_set%'; +----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Variable_name | Value | +----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | character_set | latin1 | | character_sets | latin1 big5 cp1251 cp1257 croat czech danish dec8 dos estonia euc_kr gb2312 gbk german1 greek hebrew hp8 hungarian koi8_ru koi8_ukr latin2 latin5 swe7 usa7 win1250 win1251 win1251ukr ujis sjis tis620 | +----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 2 rows in set (0.00 sec) mysql> show variables like 'version'; +---------------+---------+ | Variable_name | Value | +---------------+---------+ | version | 3.23.58 | +---------------+---------+ 1 row in set (0.00 sec)
[21 Aug 2007 10:41]
Alexander Bechkov
I'd investigated the problem. It's occured when mysql compiled with latin1 option(version 5.0.44). With utf8 all is ok. Should i change the category to "compiling"?
[30 Aug 2007 10:27]
Sveta Smirnova
Thank you for the feedback. Please provide configure string you used to compile 5.0.44
[30 Sep 2007 23:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".