Bug #1103 RLIKE charset problems
Submitted: 20 Aug 2003 3:12 Modified: 15 Dec 2003 23:02
Reporter: Sergei Golubchik Email Updates:
Status: Won't fix Impact on me:
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.1 OS:
Assigned to: Alexander Barkov CPU Architecture:Any

[20 Aug 2003 3:12] Sergei Golubchik
RLIKE does not compare accented latin1 characters the same way = or LIKE do.

How to repeat:
mysql> select 'т' like 'с';
| 'т' like 'с' |
|            1 |

mysql> select 'т' rlike 'с';
| 'т' rlike 'с' |
|             0 |
[20 Aug 2003 3:15] Sergei Golubchik
actually, characters were O' and O^
[8 Oct 2003 2:02] Alexander Barkov
Serge, I took a look into regex library. 
This bug takes place because toupper and tolower is used.
I don't know if this can be fixed easy with the current
regexp library.
[15 Dec 2003 23:02] Alexander Barkov
Monty has closed several similar regex related bugs
as "won't fix". This is not a thing we are going to
fix in the real future. I'm doing the same.