Re: Collations and REGEXP
Posted by: Roland
Date: May 17, 2006 10:58AM

I am having a similar problem: When querying a textual database which is encoded in utf8 (collation utf8_general_ci), regexes just don't work right: E.g.: SELECT * FROM ... WHERE FORM RLIKE '^[Щщ].*';
(Russian SHCHA) yields all FORMs in the text, no matter how they begin. Does anybody have an idea what is going wrong?

Best regards,
R.

Options: ReplyQuote


Subject
Views
Written By
Posted
2585
March 10, 2006 04:05AM
1658
April 25, 2006 03:34AM
1596
April 25, 2006 03:48AM
Re: Collations and REGEXP
1769
May 17, 2006 10:58AM
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.