[Firebird-website] case sensitivity - firebird

[osman <of...@su...>]

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?