Hi Thomas, Thanks for looking the matter and it will certainly help my reduce my dev work in future as I use H2 for prototyping and switch to Mysql after that. Prior to your last response I have painfully converted all my queries to case insensitive via Mysql's UPPER function :(
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. I am using hibernate 3.6 to generate all the tables, any tip how do I add the SET IGNORECASE TRUE in hibernate? Thanks in advance. Regards chungonn On Apr 30, 3:31 pm, Thomas Mueller <[email protected]> wrote: > Hi, > > I will document: > > Text comparison in MySQL is case insensitive by default, while in H2 > it is case sensitive (as in most other databases). H2 does support > case insensitive text comparison, but it needs to be set separately, > using SET IGNORECASE TRUE. This affects comparison using =, LIKE, > REGEXP. > > 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.
