Re: How can create case-insensitive database in oracle?

"Madjid Nasiri" wrote...
> Hi,
> I am basic in oracle. My Old programs write with Delphi and
 Databases:
> Access, Paradox, MySQL, Microsoft SQL.
> I write my code (SQL code) case-insensitivae, but now i need use
> oracle database. The Oracle by default is case-sensitive, How can
 used
> case-insensitive in oracle.
>
> Thanks
> Madjid Nasiri

Hi Madjid,

I hope you are going to use a version >= 8.1.7 (9.2.0.4 would be best).
Since you don't provide much infos to play around with, here are 2 two possible meanings of your post:
1. You want to store data case insensitive: do an 'insert... values(upper('Abcd'))...'.
This will put your data in upper case into the tables. 2. Your data will be mixed-case and you want to select them case insensitive:
create 'function based indexes' on every column you want to use in your where-clauses.
Then 'select ... where <column_name> = 'ABCD'.

If my assumptions about your intention are wrong, please explain it a little.

hth,
Guido Received on Thu Jan 29 2004 - 08:01:09 CET