Re: Collations and REGEXP

[Alexander Barkov]

Unfortunately, MySQL regex library does not currently
support multibyte character sets, like utf8.
It works correctly only with 8bit character sets.
We have "replace reeger library" on our TODO, but with low priority.

As a temporary workaround, you can do this:

SELECT * FROM ... WHERE CONVERT(form USING cp1251) RLIKE '^[Щщ].*';

or

SELECT * FROM ... WHERE CONVERT(form USING koi8r) RLIKE '^[Щщ].*';