[sqlalchemy] case inconsistency in reflected column names between mac and windows - Travis Kriplean - com.googlegroups.sqlalchemy

5 messages in com.googlegroups.sqlalchemy[sqlalchemy] case inconsistency in re...

From	Sent On	Attachments
Travis Kriplean	23 Oct 2007 11:12
Travis Kriplean	23 Oct 2007 12:16
Lukasz Szybalski	23 Oct 2007 12:58
Michael Bayer	23 Oct 2007 13:49
jason kirtland	23 Oct 2007 16:01

Subject:	[sqlalchemy] case inconsistency in reflected column names between mac and windows
From:	Travis Kriplean (tkri...@gmail.com)
Date:	10/23/2007 11:12:30 AM
List:	com.googlegroups.sqlalchemy

Hello,

We're running into a problem with case in the reflected column names between mac and windows both using sqlalchemy 0.4.0. For example, in our mysql database, we have a table with columns named END_YEAR and DESCRIPTION. On a windows box:

print table.c

['table.END_YEAR', 'table.DESCRIPTION']

On a mac:

print table.c

['table.end_year', 'table.description']

This causes our code not to work cross-platform, as referencing columns through table.c is case-sensitive. Obviously we could get around this, but it seems to be a bug.

We're not sure if this is a sqlalchemy issue or a discrepancy in MySQLdb between mac and windows versions. Does anyone have any insight into the cause?

Thanks, Travis