Re: Access migration woes.

Since you don't seem to be getting any "Oracle" feedback, let me suggest that you look at Informix :-)

Object Names : Informix 2000 allows object naming to 128 characters.

Case insensitive searches (Access's DOS feature, I suppose) can be accomplished using Informix's built-in string manipulation functions. For example,

SELECT ...
FROM table1, table2
WHERE UPPER(table1.col1) = UPPER(table2.col1)

For more details on these and the tons of other goodies that Informix offers, take a peek at http://www.informix.com/answers/ or fire your questions at comp.databases.informix

Rudy

Tim Uckun wrote:

> Hello everybody.
> I am planning on migrating from Microsoft access toOracle. There are two
> major hurdles to overcome before I can do this though.
> One is that Access can have object named up to 255 characters long while
> Oracle is limited to thirty or so.
> Two is that Access does not do a case sensitive search in where clauses
> while Oracle cares about case. In access where field='something' and
> where field='Something' yield the same results.
>
> I am hoping somebody here can tell me how to get around these
> limitations (features?) of oracle.
>
> If these can not be accomplished I may be forced to upsize to SQL server
> which I am hoping to avoid.
Received on Wed Mar 22 2000 - 00:00:00 CST