Some databases convert them to uppercase! Oracle is a prominent example!

It took me once some ours to locate a bug resulting from this "feature".

This reminds me of another post I did some time before, but where nobody replied. Shouldn't tags for creating sql-statements in ZSQL (like dtml-sqltest) quote the variables by default in order to prevent unexpected conversions by the database? I had to patch Zope in order to be able do queries on a postgres db with capital column-names, because postgres converts all unquoted columnnames to lowercase. cheers, oliver