Bug #1479 REGEXP problem with hungarian language
Submitted: 4 Oct 2003 14:28 Modified: 10 Dec 2003 19:22
Reporter: Peter Horváth Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.0 OS:Windows (WindowsXP)
Assigned to: Michael Widenius CPU Architecture:Any

[4 Oct 2003 14:28] Peter Horváth 
Description:
I would like a select from some town like this: a-f g-k etc.

my code: SELECT * FROM town WHERE town_name REGEXP '^[a-f]' ORDER BY town_name

But some beginning of words are hungarian type like é,á,õ stc. This words don't select the program.

I think, my character set has a good setup, too.

How to repeat:
...

Suggested fix:
I don't know. :)
[12 Oct 2003 11:29] MySQL Verification Team 
Bar could you please analyze this.
[21 Oct 2003 0:09] Alexander Barkov 
We have another bug report about German language:

http://bugs.mysql.com/bug.php?id=1103

I don't have an idea of a quick fix.

Current regex library implementation presumes that there
are only letter cases: upper and lower case. It can't
compare accented letters the same with non-accented
counterpart.
[10 Dec 2003 19:22] Michael Widenius 
This is a limitation in the regexp library and is not likely to be fixed soon.

To go around this problem add the characters you want to match to the regexp.
[10 Dec 2003 19:22] Michael Widenius 
This is a limitation in the regexp library and is not likely to be fixed soon.

To go around this problem add the characters you want to match to the regexp.