Search code examples
firebird

Using lowercase table and field names in Firebird

I have converted a database from MySQL to Firebird. All tables name and field name are in lowercase. When I query the database, it gives me an error of table not found, because Firebird automatically converted the name of the table in the query in UPPERCASE letters, but my table name in the database is lowercase.

To query the database, I'm required to enclose the name of the table or the name of the field in double quotes, for example:

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

Is there a setting in Firebird to allow querying a database with lowercase table and field names without quoting them?

Solution

  • 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).