Hi, COLLATION is a nice working solution. Thank you. And thanks for already fixed issue https://groups.google.com/forum/#!topic/h2-database/LjcgA4Ier7Q
Regards, Max On Thursday, December 12, 2013 9:40:36 AM UTC+2, Thomas Mueller wrote: > > Hi, > > Sorry for the delay. Maybe "set collation" could be used? > > set collation en strength primary; > create table test(id int, name varchar); > insert into test values(1, 'Text'); > select * from test where name = 'text'; > select * from test where name like '%text%'; > > See also http://h2database.com/html/grammar.html#set_collation > > Regards, > Thomas > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
