Hi,

At May 30, 2003, 17:05, Svend Meyland Nicolaisen wrote:

> Can Firebird be configured to use case sensitive names?

You'll have to use quotation marks(i.e.: "TableName"."FieldName"). If
what you mean is to be able to not use quotation marks, then that
could be difficult, unless you type the object name "as is" every
time. But what happens if another database, that uses the same server,
was designed without the case sensitivity in mind.

Here's where the problem can occur:

case insensitivity:
select field1 from table1 is the same as select FIELD1 from TABLE1

case sensitivity: those 2 queries are not equal.

So, if you would setup Firebird to use case sentivity, then it would
break any applications that is not expecting the engine to be case
sensitive for the object names. So, basically, the case sensitivity
would have to be defined for each individual databases, when the
database is created. And, that the engine is able to support at the
same time case insensitive and case sensitive databases (at the
architectural level, indices are already supported with the
collations).

Even though it sounds easy, it probably would be harder to implement
and require an ODS change.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)