> (1) MySQL, MS SQL and SQLite preserve the columncase. > (2) Postgre converts all column names to lowercase. > (3) IBM-DB2 and Oracle convert all the column names into UPPERCASE.
I'm running into basically the same thing. My table DDL is generated, and it always wraps names in double quotes to avoid colliding on keywords, e.g. "table_name". Then when writing SQL, I just use "SELECT * FROM table_name", and it has worked fine in postgres. In attempting to run on H2, this statement is becoming "SELECT * FROM TABLE_NAME", and I get a table not found exception. So far I'm just wrapping everything in quotes by hand, e.g. "SELECT * FROM \"table_name\""--it works but is pretty annoying, as I have to do it for both table names and column names. I'll keep at it, but I thought I'd pitch in agreement that the upper case behavior is biting me--either preserving (since I type the table names lower case) or lowering un-quoted names would be a nice configuration option. Thanks, Stephen --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
