Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to "Case Insensitive"
There is *no* global setting.
This is because only the Microsoft Realm (aka the Evil Empire) is
case-insensitive, while the rest of the world is case-sensitive.
There are three solutions to this
- use UPPER(columnname) = <expression>
this will result in full table scans
- create redundant columns with the UPPERcased contents of the mixed case
columns and index them
- In Oracle 8i, Enterprise Edition, use function-based indexes.
Hth,
Sybrand Bakker, Oracle DBA
"Real R. Bedard" <realb_at_helixdp.com> wrote in message
news: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'
>
> similarly for ORDER BY etc.
>
> Is there a global setting for this?
>
> Your assistance is greatly appreciated.
>
> Please RSVP via e-mail
> Thanks
>
> Real R. Bedard
> realb_at_helixdp.com
>
>
>
Received on Wed Aug 02 2000 - 00:00:00 CDT