Re: case-insensitive issues

stvchien0_at_gmail.com wrote:
> Hi,
>
> We're currently porting the database from MS SQL Server 2000/2005 to
> Oracle 10g2. After doing some research, we know that we can handle the
> case-insensitivity search. However, how about "INSERT"? Let's say that
> we have the tables as below.
>
> CREATE TABLE MyTable (
> ObjId NUMBER(2) NOT NULL,
> ObjType VARCHAR2(16) NOT NULL,
> Desc VARCHAR2(128));
>
> ALTER TABLE MyTable ADD CONSTRAINT PK_MyTable PRIMAY KEY(ObjId,
> ObjType);
>
> How could I do a "case-insensitive" INSERT?
>
> For example, the second statement below will get rejected by
> Oracle...
>
> INSERT INTO MyTable(ObjId, ObjType) VALUES(1, 'TYPE1');
> INSERT INTO MyTable(ObjId, ObjType) VALUES(2, 'type1');
>
> Is the FUNCTION-BASED index the only way to go?
>
> Thanks for any advise!
>
> - Steve

The only thing not case sensitive, by default, is equalities. For example:

WHERE x = y

Everything else is case sensitive.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org