Oracle 8 and case problem

Hey,

I can't load some datasets into my Oracle 8 db. It tells me that PK not found during the load. They are there but may be of mixed case. FK(Bal100) & PK (BAL100). Dataset was originally of mixed case in Sybase or MS SQL7 and dumped. Both don't care about case. So I use a command 'set uppercase' in our load utility which converts ALL FIELDS to uppercase upon the load. This causes our load utility to freeze. (returns no error) The same thing would load into Oracle 7 with or without coverting it to upper case.

So I wonder if Oracle 8 handles case differently than Oracle 7?

The table in question is:
PK 'MAIN', references another table as FK 'MAIN'

"MAIN","USA","COMPANY NAME 7777 STREET RD. SUITE777","LEAGAN", "CA","57772","6577777383","281", "6777771354","S2",0,0,"GREEN" Thanks for the reply,

Chris G

-----Original Message-----
From: Sybrand Bakker [mailto:postmaster_at_sybrandb.demon.nl] Posted At: Wednesday, December 22, 1999 3:48 PM Posted To: server
Conversation: Oracle 8 and case problem Subject: Re: Oracle 8 and case problem

You are so vague I can only answer the direct question with a simple no

Hth,

--
Sybrand Bakker, Oracle DBA
Chris Gladwin <cgladwin_at_serviceplus.com> wrote in message news:B40434B59488D111A18A0050BAA8B7A10933CB_at_EXCHSRV1...
> Hi,
>
> I can't seem to load an Oracle 8 db. My Oracle 7.3.4 db load ok.
>
> Does Oracle 8 handle case differently than Oracle 7?
>
> Chris
>
Received on Thu Dec 23 1999 - 06:49:38 CST