RE: Problem Related to Case Sensitivity in Oracle....

The function-based index is what we use for this - it has the added benefit of being used in queries. ;-)

Regards,
Diana

-----Original Message-----
From: dgoulet_at_vicr.com [mailto:dgoulet_at_vicr.com] Sent: Monday, November 27, 2000 10:11 AM To: Multiple recipients of list ORACLE-L Subject: Re:Problem Related to Case Sensitivity in Oracle....

OH BOY!!! Step 1, get up on SoapBox.

Awadhesh

    This is not something you can do/undo in Oracle as the problem you state is
not a problem. What is happening is that good old MicroSlop never created Access as a ANSI SQL standard system. If you look in the documentation you'll
see a disclaimer to that effect. Consequently your just feeling the pain of transitioning from a toy to a real database.

Now to get off of the soapbox, and ask the real question, is the application doing something to provide consistent company names? Namely is it trying to so
an upper(company_name) during insert.

    Possible solutions, a function based index since your on 8i, a trigger during insert/update to make sure that a duplicate is not inserted using a upper
or lower function.

Dick Goulet

____________________Reply Separator____________________
Author: Awadhesh Gupta <awadhesh_at_indiamart.com>
Date:       11/25/2000 5:10 AM

Dear Sir/Madam,

        I am new to Oracle. I Have a Problem Related with the Case Sensitive Received on Mon Nov 27 2000 - 13:16:39 CST