Collations and REGEXP
Posted by: durgus
Date: March 10, 2006 04:05AM

Hi there,

Iam using the following regexpession: [[:<:]]test[[:>:]] and the utf8_unicode_ci collation. Unfortunately the collation is ignored or REGEXP doesnt work with collations. Using LIKE %test% and the utf8_unicode_ci collation does work. But i want to do a search for a word, so i dont want results like "testing".

Is there a way to use the REGEXP with a collation, or a way to use LIKE like a [[:<:]][[:>:]] REGEXP?

Options: ReplyQuote


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