Re: [binarycloud-dev] QueryManager / Standards

[Konstantin C. <Kon...@da...>]

Andreas Aderhold wrote:

> > for example, in oracle both of these queries work:
> > select newsid from news;
>
> How are the column headers returned for this query also in lowercase? Or in
> uppercase? In MySQL they are returned as typed in the query.
>

Wouldn't it be better just to define column and table names as
case-insensitive and always uppercase/lowercase them in QueryManager before
doing a MetaBase query?
Then, the user will be free in choosing their naming convention.
Doesn't Oracle (or some other databases) really support '_'? In that case,
especially, allowing the user to mix upper and lower cases in the names would
be nice. E.g. "FurbeeId" is more readable than "furbeeid" or "FURBEEID".

Just my 2 pence :-)

--
         * *       Konstantin Chuguev           Francis House
      *      *     Application Engineer         112 Hills Road
    *              Tel: +44 1223 302992         Cambridge CB2 1PQ
D  A  N  T  E      WWW: http://www.dante.net    United Kingdom