Re: Collations and REGEXP
Posted by: Alexander Barkov
Date: June 08, 2006 05:28AM

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 '^[Щщ].*';

Options: ReplyQuote


Subject
Views
Written By
Posted
2585
March 10, 2006 04:05AM
1659
April 25, 2006 03:34AM
1598
April 25, 2006 03:48AM
1770
May 17, 2006 10:58AM
Re: Collations and REGEXP
1687
June 08, 2006 05:28AM


Sorry, you can't reply to this topic. It has been closed.

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.