Subject | A couple of questions. |
---|---|
Author | Tim Uckun |
Post date | 2000-03-21T22:49:02Z |
Hello everybody.
I am planning on migrating from Microsoft access to Interbase. 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 IB
is limited to thirty or so.
Two is that Access does not do a case sensitive search in where clauses
while IB cares about case. In access where field='something' and where
field='Something' yield the same results.
I am hoping that both of these are a simple matter changing a #DEFINE in
the source code. I figure you guys would know best.
If these can not be accomplished I may be forced to upsize to SQL server
which I am hoping to avoid.
I am planning on migrating from Microsoft access to Interbase. 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 IB
is limited to thirty or so.
Two is that Access does not do a case sensitive search in where clauses
while IB cares about case. In access where field='something' and where
field='Something' yield the same results.
I am hoping that both of these are a simple matter changing a #DEFINE in
the source code. I figure you guys would know best.
If these can not be accomplished I may be forced to upsize to SQL server
which I am hoping to avoid.