Hi.

> 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:

I know that :)

> 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?

As I said: I know that. BTW, I am using Interbase since ver 5.6, then
IB 6, fb103 and now fb15.

> Note: this is the same for columns and all other object
> names.
>
> With regards,
>
> Martijn Tonies

Best regards
Fikret Hasovic
TAMP R&D Team