> At 02:42 PM 12/4/2007, Martijn Tonies wrote:
>>> Along with Eugen Konkov, I would like clarification of where case
>>> preservation would cause problems with tools that assume identifiers
>> pulled
>>> from metadata can always be quoted. Seems like it should not be a problem.
>> It will be a problem.
>>
>> Case preserving, and then quoting and re-creating objects leads to
>> case sensitive objects.

Doug Chamberlin wrote:

> Sorry, but I still don't understand. Can you present a specific example?
>

Sure. You do this:

create table BigTable (BigField varchar (20000));

The metadata is stored preserving case. A portable tool does a
show tables to get its table list and sees

...
BigTable
...

It then generates a query

select * from "BigTable";

Which fails because "BigTable" is not the same as BigTable under
the ISO SQL Standard.


Regards,


Ann