Subject Re: [firebird-support] Re: view porting problem
Author Martijn Tonies
Hi,

> > > I want to make them case sensitive!!! :)
> >
> > Why??
>
> It's easier to read.

There's a difference between case sensitive
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