Subject Re: [ib-support] [] or ""
Author Woody
From: "Ivan Prenosil" <prenosil@...>
> Currently there is problem how to show database structure.
> If table name is e.g.
> MyTable
> you know that there are lowercase letters so the output must look like
> "MyTable"
> But if table name is
> should it be shown as MYTABLE or "MYTABLE" ? Which one is "more correct" ?

This begs the question: Why would anyone "want" case sensitive names to
begin with? I just can't see me naming 2 tables "MyTable" and "MYtable" in
the same database.

> Now imagine you implement "bracket delimiters".
> Should
> be shown as MYTABLE or "MYTABLE" or [MYTBLE] ?

Neither, it should be shown as MYTABLE.

> Should
> be shown as "MY TABLE" or [MY TABLE] ?

Here, the difference is in the interpretation of the quotes and brackets.
The quotes mean to take the case sensitive approach and the brackets mean
only that a special character exists in the name. Again, we go back to the
point of: Are case sensitive names really necessary in a table or fieldname?