Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle Text index question, somewhat urgent
I'm no expert, but yes - by default, text indexes are case-insensitive (in
english at least). I believe its something to do with the Lexer preferences.
The default value of the mixed_case attribute of the basic lexer object is
NO.
HTH
David Lord
> -----Original Message-----
> From: Jonathan Gennick [mailto:listmail_at_gennick.com]
> Sent: 13 June 2002 05:33
> To: Multiple recipients of list ORACLE-L
> Subject: Oracle Text index question, somewhat urgent
>
>
> I need to ask a question of someone who understands Oracle Text
> indexes. So if you know Oracle Text, please read on.
>
> I was told that if I had a query such as the following:
>
> SELECT falls_name
> FROM waterfalls
> WHERE INSTR(UPPER(falls_directions),
> 'MACKINAC BRIDGE') <> 0;
>
> where falls_directions is a CLOB, that I can define a case-insensitive
> index using Oracle Text and then use CONTAINS to execute the query
> more efficiently:
>
> SELECT falls_name
> FROM waterfalls
> WHERE
> CONTAINS(falls_directions,'mackinac bridge') > 0;
>
> Is this correct? Is there such a thing as a case-insensitive index in
> Oracle Text? I did take a quick look at the Oracle Text manual, but
> this capability didn't leap out at me. Is "case-insensitive" the term
> Oracle Text uses? In any case, I need to verify whether what I've been
> told is correct.
>
> Jonathan Gennick --- Brighten the corner where you are
> mailto:jonathan_at_gennick.com * 906.387.1698
> http://Gennick.com * http://MichiganWaterfalls.com *
> http://ValleySpur.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jonathan Gennick
> INET: listmail_at_gennick.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
A member of the Hays plc group of companies. Hays plc is registered in England and Wales number 2150950. Registered Office Hays House Millmead Guildford Surrey GU2 4HJ.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lord, David - CSG INET: David.Lord_at_hayscsg.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Thu Jun 13 2002 - 03:58:35 CDT
![]() |
![]() |