are these column names using MixedCase ? otherwise you can probably access them in a case-insensitive fashion (oracle col names are usually case-insensitive)
On Feb 12, 11:35 am, "vkuznet" <[EMAIL PROTECTED]> wrote: > Hi, > I'm trying to develop a cross-DB application which works with ORACLE > and MySQL back-ends. > Both DBs has the same schema, but of course there is a caveat. ORACLE > has Tables and Columns in upper case and MySQL does not. That leads to > the following problem. When I construct > select(table.c.column) > I face out with problem that I need to specify lower case for column > in MySQL and upper case letters for ORACLE. With table names it's easy > I can use table aliases. But how to avoid problem with columns names. > > Thanks, > Valentin. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---