Subject Re: [firebird-support] Bug? on table naming/calling
Author Martijn Tonies

> I'm totally a newbie on Firebird so I'm not sure if I'm doing some
> banal miskate or what!
> I created a table named "Persone" and I tryed to exec this SQL
> statement:
> "select * from Persone"
> but I got the following error:
> Dynamic SQL Error
> SQL error code = -204
> Table unknown
> if I create the table naming it "PERSONE", the query above works
> properly!

Don't start calling "bug" without verifying the right syntax :-)

If you create an object with double quotes (like "Persone") - it
becomes case sensitive, unless you're using all uppercase characters.

So creating "PERSONE" - can be used as Persone, PERSoNe or
"PERSONE", but not as "Persone".

Creating it as "Persone" can ONLY be used as "Persone":

SELECT * FROM "Persone"

In my opinion, a pain in the *ss and to be avoided at all times. Many
developer tool allow you to turn ON upper-casing object names -
when creating from editors - to avoid these errors. Database
Workbench is one of these tools - see

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird & MS SQL Server.
Upscene Productions