Re: Making an Oracle Database Instance Case - Insensitive

In article <01bd154f$92af8ce0$fa31e826_at_ntnirav>, "Nirav Saraiya" <nsaraiya_at_netright.com> writes:

>Subject: Making an Oracle Database Instance Case - Insensitive
 From: "Nirav
>Saraiya" <nsaraiya_at_netright.com>

Date: 30 Dec 1997 18:19:00 GMT

I would like
>to make an oracle database use case insensitive data
 storage so that the
>following query will work

      select col1 from table1 where col1 = 'sanjay
>kumar'

     col1 may have 'SANJAY KUMAR' or 'Sanjay Kumar' but
>everything

 will be matched by the above select statement. There should be
>some

 switch/init parameter that I can set to make the database case
>insensitive.

Here's my solution. I would create a before insert or update trigger that would put the data in all upper case. Unfortunately you would have to do this with each of your user tables.

--Bob. Received on Mon Jan 19 1998 - 00:00:00 CST