tags:

views:

23

answers:

1

I have converted a database from MySQL to Firebird, all tables name and field name are in lowercase, when i query the database, give me an error of table not found because firebird convert automatically the name of table in the Query in UPPERCASE letter, but my table name in database is lowercase.

For query the database i'm obliged to enclose the name of the table or the name of the field in double quote ... For example :

SELECT "field1","field2" FROM "table"

Is there a setting in Firebird for allow to query database with table/field name in lowercase letter without quoting it ?

Thanks

+2  A: 

No. BTW, I suggest you to always create DB objects in uppercase (and without double quotes) in Firebird. This simplifies a lot, since you can access them writing in any case (even mixed case).

WarmBooter