Hi, I've tried running the query with "collation" "ENGLISH" and "PORTUGUESE_BRAZIL" does not work.
Do you have any tips for this to work? Regards, Rodrigo Macedo On 2 jul, 09:39, Thomas Mueller <[email protected]> wrote: > 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 > > athttp://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.
