Eugen.Konkov@... wrote:

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

Regards,


Ann