Re: turn off/on case insensetive search in Oracle DBMS

"Andy Hallam" <ahm_at_exel.co.uk> wrote in message news:9jrs1g$16b$1_at_reader-00.news.insnet.cw.net...
> Yes, you could do this - for most developers though this is totally
> impractical.
>
> It's just another thing that ORACLE doesn't cater for...Ohh, sorry, I mean
> doesn't lower itself to the level of all the other RDBMS.
>

Actually the most common workaround would be to include an uppercase column for your searchable column and populate this with a before insert trigger. Current versions of Oracle also allow you to create an index on UPPER(column_name).

Personally I'm of the view that the Oracle way is the correct way to do this, though I'll admit that others may and do disagree. For me data *is case sensitive in the general case. If you have a specific requirement you are better coding for it yourself. How do these other marvellously flexible databases cope with the need for both case sensitive and case insensitive columns in the same application?

--
Niall Litchfield
Oracle DBA
Audit Commission UK

Legal disclaimer required by my employer
****************************************************************************
**
This email contains information intended for the addressee only.
 It may be confidential and may be the subject of legal and/or professional
privilege.
Any dissemination, distribution, copyright or use of this communication
without prior permission of the addressee is strictly prohibited.
****************************************************************************
**