Hi, I am trying to migrate a project to H2 from SQL Server and Sybase. It contains small but many tables with hundreds of pieces of SQL. The problem I am having is that I rely on the field names to be returned as mixed case in the java code (for string matches etc) but also query the fields unquoted in the SQL which means the queries fail. For example
select 1 Test into #test select Test from #test This works fine on both Sybase and SQL Server but fails on H2. Obviously select "Test" from #test works correctly but I'd rather not have to modify all my SQL during the migration. Is there any compatibility mode which would allow me to do this? Thanks, Andrew -- 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.
