Re: Help Case Sensitivity

From: Chris Gadsby <chris_gadsby_at_compuserve.com>
Date: Wed, 01 Jul 1998 18:51:23 -0400
Message-ID: <01bda543$f1c8c320$1d01ab9f_at_cjgnote>


Henry,

Thanks for the suggestion.

That basically is what I am having to do. My problem though is that the client application has a very good search facility in built that allows searches by any field on the form. This helps the client but is not something that can be programmed to intercept and change the SQL it issues.... and as you say indexes are pretty well useless.

What got me curious is that someone told me that Oracle v7.3 had an installatin setting to determine if the data was held in a case sensitive manner or not. Its not something I've ever heard of before and judging form the lack of confirmation from the newsgroup is a red herring (or just wishfull thinking)

Thanks

Chris

Henry Talbot <talbot_at_idt.net> wrote in article <35968d0a.2547966_at_news.idt.net>...
> Chris,
>
> The only thing I can suggest is to use the TOUPPER or TOLOWER function
> in your query , i.e.:
> SELECT * FROM Table WHERE TOUPPER(col) = 'A';
>
> I don't know if this is an Oracle specific SQL extension or ANSI. The
> downside of doing this is that if the column has an index on it, the
> index gets clobbered, so you get a sequential search which can cause a
> severe performance impact. In that case I've added another column
> that is the search column translated into Upper case, which I then
> indexed.
>
> Hope this helps,
> Hank Talbot
>
> On Wed, 17 Jun 1998 14:45:49 -0400, "Chris Gadsby"
> <chris_gadsby_at_compuserve.com> wrote:
>
> >Hi,
> >
> >
> >Is there any way to make an oracle database case insensitive? (ie where
> >col = 'A' will find the same set as where col = 'a' )
> >
> >It would be of immense help of I could do this some how without having
to
> >rewite the client applications to force the data into all upper case or
> >something. I'm looking for some sort of compatability with Sybase / SQL
> >Server which can be set to be case insensitive.
> >
> >Pleae help if you can!
> >
> >Thanks
> >
> >Chris Gadsby
>
>
Received on Thu Jul 02 1998 - 00:51:23 CEST

Original text of this message