Subject | Re: [firebird-support] Re: view porting problem |
---|---|
Author | Martijn Tonies |
Post date | 2004-01-23T10:47:20Z |
Hi,
and case preserving. With Firebird, case sensitive
means, that if you create a table "TestTable", you
ALWAYS need to use the double quotes and
say:
SELECT *
FROM "TestTable"
If you mistakingly type "Testtable" -> it fails.
If you type: testtable -> it fails
While if you create a table "TESTTABLE" (or
without quotes), this works:
SELECT *
FROM TestTable
FROM Testtable
FROM testtable
See the difference?
Note: this is the same for columns and all other object
names.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com
> > > I want to make them case sensitive!!! :)There's a difference between case sensitive
> >
> > Why??
>
> It's easier to read.
and case preserving. With Firebird, case sensitive
means, that if you create a table "TestTable", you
ALWAYS need to use the double quotes and
say:
SELECT *
FROM "TestTable"
If you mistakingly type "Testtable" -> it fails.
If you type: testtable -> it fails
While if you create a table "TESTTABLE" (or
without quotes), this works:
SELECT *
FROM TestTable
FROM Testtable
FROM testtable
See the difference?
Note: this is the same for columns and all other object
names.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com