Hello 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.
>
> 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.
>
> Does anyone know if it's possible to create objects with the exact
> same casing as the script, ie. create table Bob will create a table
> named Bob, not BOB.
>
> Any hints would be greatly appreciated.

Yes, that is possible. If you use mixed case (and/or special characters)
inside double quotes, the name becomes case sensitive.

eg:

create table "MyTable"

Do note, however, that you ALWAYS need the double quotes then:

select * from "MyTable"

cause this won't work:

select * from MyTable


Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com