Hi,

I'm trying to migrate the database (ASA 8.0) of a big application on a
Firebird database (thanks to Firebird 1.5 and Firebird ODBC driver 1.2),
but I have some problems, if you could help me...


In this application, I have several kinds of SQL statements : tables names
and fields names are in lower case, with "" or not.

For instance:
select "firstname" from "client"; (1)
OR select firstname from client; (2)


If I create my Firebird tables with specifying the name in lower case and
in " ", only statements of kind (1) runs.
If I create them without " " and in lower case, only the statement (2) run.

I know that Firebird is case insensitive if we create our objects with
their name without " ". Their name are automatically converted in upper
case, and that's why I think that the statement 1 can't run int this case.


I wonder whether we can create objects in Firebird whose name would be in
lower case and WITHOUT USING "".

I MUSTN'T CHANGE the statements of my application. Does it exist an other
solution?

I've seen that some options are configurable on the driver ODBC for the
case sensitivity, but I am not able to make them function. I don't know if
it could run...


Thanks for your help.