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:
None 
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 
Description:
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.