Hi,
when i create a Firebird table without "", it automatically creates it (name
and fields name) into upper case. so I can execute a SQL statement like :
SELECT * FROM mytable;
but not :
SELECT * FROM "mytable"; (due to the case sensitivity)
I have a big application which uses these 2 kinds of statements , and i
can't modify it.
I think its impossible to make Firebird be likely to accept these requests
unless configuring its ODBC driver.
In fact, I ve seen in the driver configuration some "Extended Identifier
Properties" like case sensitivity, ... but I can't make them work.
Does anybody know?
Is it possible to solve my problem thanks to that?
Thanks for your help?
|