case sensitivity

View: New views
1 Messages — Rating Filter:   Alert me  

case sensitivity

by OsMaN-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

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?




-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test