In your firm we have standard to write names with mixed case like myTable, fieldID
This has good visual effect and is not annoying like MY_TABLE, FIELD_ID,
VERYLONGFIELDNAME or VERY_LONG_FIELD_NAME
This problem appears while querying data from DB
"select fieldID ..." will return FIELDID as name of column =(

>Many people find this very annoying ...

Yes, that is annoying too. Now, when we plan to migrate to FireBird
it is too hard to read object names like 'VERYLONGFIELDNAME'
That is also seems impossible to quote all object names in our scripts
150 - 200K lines of code. Renaming all using '_' like VERY_LONG_FIELD_NAME is aldo will be VERY hard

That will very usefull feature if there will be an ability to refer to objects
case sensitively without quoting
select fieldID from myTable;

----- Original Message -----
From: Helen Borrie
To: firebird-support@yahoogroups.com
Sent: Tuesday, December 04, 2007 12:19 PM
Subject: Re: [firebird-support] Upper case behaviour


At 08:53 PM 4/12/2007, you wrote:
>Hello
>Can I disable server to uppercase object names?
>So when I write
>select fieldID from myTable
>server return 'fieldID' from 'myTable' not 'FIELDID' from 'MYTABLE'

Disable? - No.

But you can define object names to be case-sensitive by use of the ISO-standard double-quoting convention when creating the object, e.g.,

create table "MyTable" (
"fieldID" integer,
"data" varchar(50),
constraint "PK_MyTable" primary key("fieldID"))

Many people find this very annoying because, once you define these identifiers with double-quotes, you must always refer to them in double-quotes.

./heLen




[Non-text portions of this message have been removed]