Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

searching case sensitive and non case sensitive

jymarkusgJan 16 2013 — edited Jan 17 2013

Hi!

We're using 11g enterprise edition for our product. In the past we used the LIKE operator to search our string fields. Therefore we had a function based index (UPPER(stringfield)) for non case sensitive and a second normal index for case sensitive search.

Now we want to use oracle text option for searching (better performance, search similar words,...). How does oracle text work with case sensitive and none case sensitive?

As far as I know I can define a lexer and set a property for case OR non case sensitive... But I need both... Do I need 2 text indizes?!?!?!

Thanks
Markus

This post has been answered by Roger Ford-Oracle on Jan 17 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 14 2013

Added on Jan 16 2013

#database-key-features, #text

3 comments

1,079 views