Hi, Thanks for your reply, but my problem is not "ignore case". I solved this by using the lower function. The problem is the graphic accent that is saved in the database, but when I do a search using the same name without graphic accent, the result does not come.
Do you understand me? Regards, Rodrigo Macedo On 2 jul, 04:33, michaelm <[email protected]> wrote: > Hi, > > Note that this behaviour is documented > inhttp://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.
