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 Insensitve Text Searching

Re: Case Insensitve Text Searching

From: Benjamin Zhang <bzhang_at_ei.org>
Date: 1997/05/21
Message-ID: <3383662D.65A3@ei.org>#1/1

Brad Pliner wrote:
>
> What's the best way to do case insensitive text searching?
>
> Here's what I'm considering:
> Suppose I'm searching the names of movies. I'm create a field for the name,
> as it will be displayed to the user "The Long Kiss Goodnight". Additionally
> I'll create a field for the name, all capitalized, and strip out all
> instances of "the", "of", etc. ("LONG KISS GOODNIGHT"). I'll use that field
> to search by.
>
> Any thoughts? Is this the best way to do this?
>
> - Brad
>
> _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
> _
> Bradley S. Pliner mailto:brad_at_pliner.com Internet Software
> Pliner Products http://www.pliner.com/ Custom Development
> - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
> -

Try ConText option. That will do the work.

ben Received on Wed May 21 1997 - 00:00:00 CDT

Original text of this message

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