Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re:Problem Related to Case Sensitivity in Oracle....

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

From: <dgoulet_at_vicr.com>
Date: Mon, 27 Nov 2000 10:05:03 -0500
Message-Id: <10693.122944@fatcity.com>


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____________________
Subject: Problem Related to Case Sensitivity in Oracle.... 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 Nature of Oracle 8i.

        I Had an Application in VB and MS-Access as Back-End. We Were Facing Problem with the MS-Access Database as it has become so Large (about 950 MB). Now we have transferred MS-Access Database to Oracle-8i. But This created a problem for Us...I am describing my problem...

We Have A Company Table which Contains Fields Like "CompanyName",
"ContactPerson", "Address", "City", "State", "Pin", "Country", "Phone",
"Fax" etc....

        This table has UNIQUE key indexed on "CompanyName" Field. But It Allows Two Companies to be entered with the same Name (With Different case). For Example... I Have Already a Record With CompanyName = "ABC Overseas". Now When I am entering another Record with the Name "abc overseas". Oracle Allows to do that...But this doesn't happen with MS-Access or SQL (They Treat these two companies same). I just want to know that how to make oracle to Treat these two companies as SAME. I don't want these two companies to be entered.

        I Can use query "select Companyname from company where UPPER(companyname)
= 'UPPER("abc overseas")' to check whether a company already exist with this Name... But This makes Application Too slow as there are about 50,000 Records in the table and application is being used by so many users.

        So Please suggest me the way to tackle this problem. Is there any Setting
in Oracle by which Oracle will not be Case Sensitive.

        Ur Any help or support can make my work very easy...

        Please Suggest me ASAP...

        Thanks and Regards
        -AwadheshDear Mr. Avinash,

        I am new to Oracle. I Have a Problem Related with the Case Sensitive
Nature of Oracle 8i.

        I Had an Application in VB and MS-Access as Back-End. We Were Facing Problem with the MS-Access Database as it has become so Large (about 950 MB). Now we have transferred MS-Access Database to Oracle-8i. But This created a problem for Us...I am describing my problem...

We Have A Company Table which Contains Fields Like "CompanyName",
"ContactPerson", "Address", "City", "State", "Pin", "Country", "Phone",
"Fax" etc....

        This table has UNIQUE key indexed on "CompanyName" Field. But It Allows Two Companies to be entered with the same Name (With Different case). For Example... I Have Already a Record With CompanyName = "ABC Overseas". Now When I am entering another Record with the Name "abc overseas". Oracle Allows to do that...But this doesn't happen with MS-Access or SQL (They Treat these two companies same). I just want to know that how to make oracle to Treat these two companies as SAME. I don't want these two companies to be entered.

        I Can use query "select Companyname from company where UPPER(companyname)
= 'UPPER("abc overseas")' to check whether a company already exist with this Name... But This makes Application Too slow as there are about 50,000 Records in the table and application is being used by so many users.

        So Please suggest me the way to tackle this problem. Is there any Setting
in Oracle by which Oracle will not be Case Sensitive.

        Ur Any help or support can make my work very easy...

        Please Suggest me ASAP...

        Thanks and Regards
        -Awadhesh
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Awadhesh Gupta
  INET: awadhesh_at_indiamart.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
Received on Mon Nov 27 2000 - 09:05:03 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US