Subject Re: [firebird-support] No case sensitive column names
Author Martijn Tonies

>> Is there a way to store the case of the column names but then to get
>> them without case sensitive feature?
>> For example, I have the "EnterDate" column in a table.
>> If I do "select * from Customers" or I use a report designer, I would
>> like to see the column name as "EnterDate", not "ENTERDATE". (Firebird
>> store all column names in upper case if you do not provide "")
>> I know that I can use the "" in Firebird to keep the case, but then,
>> the column is case sensitive.
>> I would like to store the column name as EnterDate, but then I would
>> need to use EnterDate or ENTERDATE or ENTERDate in the Select or Where
>> clause.
>> Do you know a way to do it?

Don't use "select *", but use column names instead:

select enterdate as "Enter date" from ...

This will showup just as is in your report editor.

Alternatively, create a "report view" for your report-related queries.

create view Report_Customers ("Enter date", ... other columns )
select enterdate, other columns

you can joins etc in the view too, that will simply your report writing.

With regards,

Martijn Tonies
Upscene Productions

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum: