empire-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From McKinley <mckinley1...@gmail.com>
Subject Re: Why auto UPPER CASE for the column name
Date Mon, 08 Feb 2010 00:52:47 GMT
For what it is worth, in Empire-db I maintain a personal patch during all
updates that turns upper case off. I use the straight table and column names
in codegen too and I apply quoted identifiers for the string name on each.

Thanks,

McKinley

On Sun, Feb 7, 2010 at 11:38 PM, Francis De Brabandere
<francisdb@gmail.com>wrote:

> Rainer?
>
> On Sun, Jan 10, 2010 at 7:43 PM, Exxos <hatufr@yahoo.com> wrote:
>
>> Hi,
>>
>> db.album.title.as("title") will generates the following SQL column name
>> >>> "TITLE" in upper case in the SQL command...
>>
>> Is there any reason?
>>
>> cmdUnion.select(db.album.id
>> ,db.album.title,db.album.index,db.album.serieId,db.album.title.as
>> ("title"));
>> SELECT t1.alb_id, t1.alb_title, t1.alb_index, t1.alb_ser_id, t1.alb_title
>> AS TITLE
>>
>> This is not consistent in case of using lower case for defining columns
>> name and this is too intrusive... I think this is the responsability of the
>> developper and not empire-db to decide.
>>
>> Please advise.
>>
>> /Cheers
>>
>>
>
>
> --
> http://www.somatik.be
> Microsoft gives you windows, Linux gives you the whole house.
>

Mime
View raw message