Subject | Re: [firebird-support] Querying field names of a relation |
---|---|
Author | Martijn Tonies |
Post date | 2004-03-29T12:15:04Z |
Hi Christian,
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
> > Perhaps case-sensitive table names?If you enter them case sensitive with double quotes,
>
> 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.
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