Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Case in-sensitive searches

Re: Case in-sensitive searches

From: Christopher M. Day <christopher.day_at_rdbms.freeserve.co.uk>
Date: Fri, 20 Oct 2000 16:56:38 +0100
Message-ID: <39F06B36.7AC19627@rdbms.freeserve.co.uk> 






Bji,



Couple of options 



    
  
  1.   Load all data in one case either upper or lower
  
  2.   Use Oracle8i functional indexes and create an UPPER(column) index
and code this in all queries






Chris



Bji wrote:


> 

> Does any one know, is it possible to configure oracle server to do case

> in-search whenever any query is performed.

> Thanks

> Bji

Received on Fri Oct 20 2000 - 10:56:38 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US