Daniel,

> >> You don't imagine how ALL CAPS, small caps and Mixed Caps was discussed
> >> last days. :-)
> >>
> >> If you put the table name (or other identifier) enclosed on quotes, you
> >> SHOULD use it everywhere with the quotes
>
> > Unless you use all-caps :-) ... Then it's case insensitive again.
>
> > So, in general, if you want to avoid case problems, don't use quotes.

But

> > Firebird isn't case preserving either.
>
> > If you want to use case, reserved words and make it case preserving,
> > use double quotes.
>
> The problem that he's having is that some tools will automatically put
> the double quotes around identifiers(table, fields, domains to name a
> few), if the identifier was not entered in all caps. I know EMS
> Quickdesk does that and I don't know if the recent versions still do
> it(I'm still using version 2.9). The option that I have with Quickdesk
> is one check mark on the database registration form to automatically
> use all-caps for identifiers, and by default it's unchecked.

Needless to say, you should use another tool :-)

Database Workbench has mixed identifiers turned OFF by default
and will warn you if you're using reserved words.

I wonder if I should warn the user for special characters like "-" or
"%" as well.

Furthermore, Database Workbench will ONLY quote Firebird
reserved words, SQL reserved words or mixed-case/special
character indentifiers. All others are unquoted. Always. Regardless
of "mixes case" settings.

> The tool shouldn't do this unless an option exists to automatically
> put identifiers in double-quotes, or that the user implicitly placed
> the double-quotes. This is were some newbies get confused, I know I
> was when I started to use Interbase 6 beta(before Firebird's
> existence).

Care for a competitive upgrade? :-)

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com