Hi all,

I am trying to get a third party application (which claims to be
platform independent because all DB work is done by ODBC) to use
Firebird (2.1.2.18118) as DB. The application has its own administrator
interface which manages the installation/creation of tables and indices.
This is where I run into trouble: the application uses quotations to
create tables and columns (which is fine because it also uses several
reserved words for column names), but does not use the quotations
consistently!
The best example for this behaviour: the first commands it sends:
create table "mytable" ( "some_field" integer, ......
followed by
alter table mytable add primary key ......

Firebird creates the lowercase table but cannot add the primary key..
This inconsistent use of quotes is used on several occasions in normal
use of the application (for instance, deleting temp tables is done by:
delete from "mytable").

I know, the actual problem lies with the third party software, but
asking for changes is a no-go. The application is used by 99% of its
client base on Oracle or MS SQL..

MySQL has a workaround for this: it allows forcing the table names to
lower case by using the option: lower_case_table_names=1

Is there a way to make this happen in Firebird as well?
Alternatively: strict case sensitive behaviour is also fine. (luckily
the application is consistent in the use of capitals...)

Thanks,
Johann