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