Hi, Note that this behaviour is documented in http://www.h2database.com/html/features.html#compatibility
What is said is : "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, Michaël On 2 juil, 01:42, "GMail" <[email protected]> wrote: > Hi, > > I’m Brasilian. > > I have a problem in H2 version 1.2.138. > > When I run the query “select * from cliente where lower(nome) like > lower(‘paula sartório%’)” in my database, the result is one tuple. It´s OK, > but when I run the query “select * from cliente where lower(nome) like > lower(‘paula sartorio%’)”, the result is empty. > > In my database the table "cliente" on column "nome" the value is “Paula > Sartório”. > > FYI: Both queries run on MySQL and return the same result. > > Att, > > Rodrigo Macedo -- 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.
