case insensitive identifiers in queries
Posted by: Chris Cheshire
Date: July 17, 2012 01:20PM

I am porting over a web app from an oracle back end to a mysql backend and I am having trouble with table names being case sensitive in the queries. I understand that the tables are now stored as lower case names due to the configuration, and I'm OK with that.

What I would like to know is if there is a parameter I can pass to the JDBC connection to make the queries work with case-insensitive identifiers despite this, or do I have to rewrite all of my SQL to make sure all the table names are in lower case?


Thanks

Chris

Options: ReplyQuote


Subject
Written By
Posted
case insensitive identifiers in queries
July 17, 2012 01:20PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.