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?
Subject
Views
Written By
Posted
Collations and REGEXP
2615
March 10, 2006 04:05AM
1677
April 25, 2006 03:34AM
1615
April 25, 2006 03:48AM
1787
May 17, 2006 10:58AM
1703
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.