Hi, > I found out that regexp when use in H2 mysql compatibility mode is > case sensitive whereas it is not in mysql. Is this the expected > behavior?
Yes, it is expected. H2 is not 100% compatible to all other databases - if it would, then it would be 100 times larger I guess. H2 just tries to be compatible where possible and where it makes sense. > I also realize that H2 mysql mode does not recognize the > RLIKE token is this also an expected behaviour? Yes it is expected. 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.
