Home » Server Options » Text & interMedia » How to ignore case in CLOB search?
How to ignore case in CLOB search? [message #75999] Tue, 19 November 2002 10:25 Go to next message
Daniel Kowalik
Messages: 1
Registered: November 2002
Junior Member
Hi all,
i've jus got stucked by a strange problem. I'm trying to do a case insensitive search on CLOB column and it seems like it wasn't possible. I've checked the MIXED_CASE property for lexer and it's set up as YES. I've also created an index for that column and i've tried with ctxsys.context and ctxsys.ctxcat index. In all cases i'm not able to find required texts (aaa,AAA).

Does anybody have a clue?

Bests
daniel
Re: How to ignore case in CLOB search? [message #76020 is a reply to message #75999] Wed, 22 January 2003 13:22 Go to previous message
Shuk Tse
Messages: 1
Registered: January 2003
Junior Member
According to Oracle, the solution is to create a context index on the CLOB column and make it a context search. This search capability will require the Intermedia Text option.
Previous Topic: object CTXSYS.CONTAINS is invalid
Next Topic: get Image into oracle
Goto Forum:
  


Current Time: Thu Mar 28 20:13:45 CDT 2024