> > the problem is not case sensetive or case insensetive
> > the problem is storing object name as UPPERCASE and not AS IS
> >
> > SOIGETUNREADABLENAMESWHILEMIGRATINGTOFIREBIRDFROMMYSQL
> >
>
> Don't get me started on case in MySQL. Table names in MySQL
> are case sensitive and case preserving on Linux and some
> Mac/OS file systems. They are case insensitive and not
> case preserving by default on Windows and other Mac/OS
> systems. There is an option to make those systems case
> preserving, but it doesn't work with the InnoDB storage
> engine.

:-)

> A practical problem for Firebird is that tools depend on
> the fact that they can always quote identifiers when constructing
> statements from the metadata. If we change to case-preserving,
> that will fail.

If the difference between case sensitive and case preserving is
stored in the metadata tables, those tools "just" need to support
this new feature.

For example, in Database Workbench I'm checking to see if
it's not all uppercase, if so -> quoted. If it has special characters ->
quoted, and so on.

If it's a simple name, all uppercase -> not quoted. Quite easy actually.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com