Rails - Jul 2005 - [AR] Are column names case-sensitive?

Hi!

At the moment I''m working on the DB2 adapter for ActiveRecord and had
a minor problem with test/fixtures/computers.yml. The attribute
extendedWarranty is used in a test case and obviously its case is
significant. For DB2 that''s sub-optimal, because DB2 is not
case-sensitive and the column name I get from DB2 CLI is
EXTENDEDWARRANTY.

Looking at the other adapters I could not find a convention regarding
the column names. The DB2 and OCI adapters turn column names to lower
case and all the other adapters leave them untouched.

I suggest to always turn column names to lower case.

Any comments?

Cheers

Maik

On 7/19/05, contact-CKba8aKGf+ewktNWMKzPnQ@public.gmane.org
<contact-CKba8aKGf+ewktNWMKzPnQ@public.gmane.org>
wrote:
> I suggest to always turn column names to lower case.
+1