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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.051 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.