Re: Moving from MS to Oracle

From: Graduate Associates Ltd <phatcher_at_terra.cix.co.uk>
Date: 2000/03/07
Message-ID: <memo.20000307191232.16279H@terra.compulink.co.uk>#1/1

One major gotcha is that Oracle is case-sensitive and there's no way of turning it off, so all your searching fields need to flipped to one case or the other to get 'nice' behaviour.

The route we've taken is to code generic SQL, using the ODBC escape features, holding this in the data tier rather than stored procs so that the only thing needed on the server is the schema.

Another nasty is that Oracle still don't support ANSI join syntax and there are problems in all the drivers in generating the required Oracle syntax - primarily to do with nested outer joins so it may not hit you.

Regards

Paul Hatcher, MCSD
Principal Consultant
Graduate Associates Ltd Received on Tue Mar 07 2000 - 00:00:00 CST