Re: How to "Case Insensitive"

From: stevieG <stevie-g_at_gmx.de>
Date: 2000/08/02
Message-ID: <8ma3pi$c0r$12$1@news.t-online.com>#1/1

Real R. Bedard <realb_at_helixdp.com> schrieb in im Newsbeitrag: SG_h5.687$Z2.12800_at_nnrp1.uunet.ca...
> How do I make Oracle queries (from all users in all
> databases/schemas/tables) case insensitive.
>
> example:
> SELECT * FROM mytable WHERE name = 'fred'
> should have the same result as
> SELECT * FROM mytable WHERE name = 'FReD'
you should try:

SELECT * FROM mytable WHERE upper(name) = upper('FReD');

but be aware, an index on name will not be used, while it is not an user defined index.

>
> similarly for ORDER BY etc.
>
> Is there a global setting for this?

I´ve never heard about a global setting.

stevieG Received on Wed Aug 02 2000 - 00:00:00 CDT