Re: Oracle 12c Case insensitive searches

Hi Zahir!

Setting NLS_COMP to "linguistic" will also entail using function and will have just the same cost as the functional index. I don't see the problem with the functional indices or Oracle*Text. If, for some reason, Oracle*Text is not good enough, there are always things like Lucene or Sphinx. There are also other tricks: having a computed column and then indexing it with a normal index. If push comes to shave, it is possible to create post insert or update trigger which would fill an additional real column with lower(original column), which would do case insensitive search at the expense of some space. Every method of the case insensitive search would have to use function to bring the string to a uniform case, in order to perform case-insensitive search. The only choice you have is when to invoke the function. You can invoke it during the search itself or at the point of inserting/updating the row.

Regards

On 04/04/2018 12:19 PM, Zahir Mohideen wrote:
> You can set the nls settings , perform the case insensitive search.
>
>
> http://mfzahirdba.blogspot.com/2010/04/case-sensitiveness.html
>
> - Zahir
>
> Zahir Mohideen
> http://mfzahirdba.blogspot.com/
>
>
> /Nothing so *GREAT *was achieved without enthusiasm/
>
> On Tue, Apr 3, 2018 at 5:36 PM, Mladen Gogala <gogala.mladen_at_gmail.com
> <mailto:gogala.mladen_at_gmail.com>> wrote:
>
> Better how? What aspect of case insensitive search needs improvement?
>
>
> On 04/03/2018 11:37 AM, Sanjay Mishra (Redacted sender smishra_97
> for DMARC) wrote:
>> Is there any good solution for Case insensitive search to one or
>> two col level on table ?  Is any new featured added in any 12c
>> flavor that provide better solution over old Index/Function based
>> Index/Context index ?
>>
>> TIA
>> Sanjay
>
> --
> Mladen Gogala
> Database Consultant
> Tel: (347) 321-1217
>
>

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217


--
http://www.freelists.org/webpage/oracle-l