Subject Re: [firebird-support] Querying field names of a relation
Author Martijn Tonies
Hi Christian,

> > Perhaps case-sensitive table names?
>
> Yes, of course.
> Table names that I entered like 'T_Benutzer' were
> stored as 'T_BENUTZER'.
>
> I am wondering why I did not think of this.
>
> Anyway, thanks to you and Martijn.

If you enter them case sensitive with double quotes,
like this:

CREATE TABLE "T_Benutzer"

then they will become case sensitive. If you don't use
the double quotes, they will be case insensitive
and uppercased.

If you create your tables case sensitive, you have to
use the double quotes always:

SELECT *
FROM "T_Benutzer"

and so on.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com