Hi, > May I suggest that case insensitivity be automatically set when MySQL > mode is being used in H2 instead of doing it explicitly this would > make H2's MySQL mode better matches the actual behavior of MySQL.
That's an option, but it would mean you can't enable the MySQL mode if there are already tables in the database (see the SET IGNORECASE documenation). Instead, I will improve the documentation. > am using hibernate 3.6 to generate all the tables, any tip how do I > add the SET IGNORECASE TRUE in hibernate? Yes, you could add it to the database URL: jdbc:h2:~/test;MODE=MySQL;IGNORECASE=TRUE Regards, Thomas -- 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.
