mixed Case Field names in the database columns

I'm trying to query my Postgres database through an ODBC data source
in Windows (Excel & Access).

I've found that Excel does not like mixed case field names and the
recommendation for linked SQL servers is to use all lower case names.
I assume this also applies to other types of connections with the
windows ODBC driver.
http://www.postgresonline.com/journal/index.php?/archives/46-Setting-up-PostgreSQL-as-a-Linked-Server-in-Microsoft-SQL-Server-64-bit.html

I know that there is a setting to configure the db_table in django,
but I haven't found any similar setting for the field names. What
approach would you recommend to address this problem. It seems that
my options are:

1) rename all the fields to lower case in django and in the db
2) find a way to continue to use mixed case in my application but
change the tables
3) find a way to get the ODBC driver to handle mixed cases so that
everything can stay mixed case

-Tim Langeman
Akron, PA

--

You received this message because you are subscribed to the Google Groups "Django users" group.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to django-users+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.