At 05:22 AM 9/05/2005 +0000, you wrote:

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

OK, I think what you are encountering is query-builder tools that offer you
a column list, correct?

These tools build these selection lists by querying the system tables. All
of the metadata of a Firebird database are stored and maintained in these
tables - so, of course, when one queries

select rdb$relation_name from rdb$relations
where rdb$relation_name not starting with 'RDB$'

one gets a list of table names in upper case - because they are stored as
uppercase strings!!

Incidentally, running the above query as this:

select rdb$relation_name from rdb$relations
where rdb$relation_name not starting with 'rdb$'

is going to yield all of the names of the system tables as well, since all
of the system tables' names are ALSO stored in uppercase. :-)


./heLen