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?

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: Re: sqlcxt error
Next Topic: Re: DBMS_JOB
Goto Forum:

Current Time: Mon Aug 21 09:09:02 CDT 2017

Total time taken to generate the page: 0.04886 seconds