Hi, In that case, SET COLLATION needs to be used: http://h2database.com/html/grammar.html#set_collation
Regards, Thomas On Sat, Jul 2, 2011 at 1:49 PM, Rodrigo Macedo <[email protected]> wrote: > 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. > > -- 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.
