Subject Re: [firebird-support] Case-sensitive object names
Author Paul Vinkenoog
Hi Dany,

>> It may well be that this question has come up numerous times but
>> I'll be darned if I can find any reference to it.

There's a section on it in the Quick Start Guide: Working with
databases -> Firebird SQL -> Things to know about strings ->
Double-quoted identifiers

>> It seems, regardless of the script, all objects are created with
>> uppercase names. I am accessing Firebird from a .NET app that uses
>> Wilson's O/R Mapper. I keep getting error messages that said
>> this-or-that table or field could not be found. If I change it to
>> uppercase names then it works.

A tool that automatically encloses identifiers in quotes without
asking you is seriously flawed. Martijn has already shown how you can
create objects with case-sensitive names, but if I were you I'd first
find out if you can switch off this behaviour in your app.


Greetings,
Paul Vinkenoog