| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Problem Related to Case Sensitivity in Oracle....
Why do you not insert the UPPER(CompanyName) instead of the CompanuName
itself ? If you can't do that you could create a trigger that would uper
it.
Djordje
> 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 Sat Nov 25 2000 - 08:17:10 CST
 |
 |