--- In firebird-support@yahoogroups.com, "Adam" <s3057043@y...> wrote:

>
> >
> > OK; but I can't *create* a table named tblItem, right? Would be
> > TBLITEM...at least the db management tools I've looked at all change
> > to uppercase. Yes it is good if firebird sees tblItem and knows it's
> > TBLITEM, but I'd rather have the table and field names themselves have
> > the flex.
>
> I am a bit confused by your questions.
> What version of Firebird are you running, the following will work on
> 1.5.2. The management tools probably have some historic reason for
> doing it that way.
>
> create table tblitem
> (
> id integer
> );
>
> commit;
>
> select count(*) from TbLIteM;
> select count(*) from tblitem;
> select count(*) from TBLITEM;

Hi Adam - well, if firebird can do that, then I'm really happy. It
seems that all three of the main tools I'm evaluating for use with
firebird (1.5.2) force uppercase...DB Workbench and DB Visualiser do
anyways, I'm now having problems with SQL Hammer and can't test that
right now.