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 On Fri, Nov 8, 2013 at 11:12 AM, Max Sidnin <[email protected]> wrote: > Hi, sorry for the late response. > > > Could you describe the real scenario please? >> > > > For example we have next table with "ignorecase=true": > > +-------------+----------------+ > | *Prefix* | *Name* | > +-------------+----------------+ > | Mr. | Max | > +-------------+----------------+ > | Mr. | Thomas | > +-------------+----------------+ > | Mr. | Mike | > +-------------+----------------+ > | Ms. | Mona | > +-------------+----------------+ > > User can search by some kind of object presentation: > ---------------------------------------------------------- > SELECT * FROM table WHERE CONCAT(Prefix, ' ', Name) LIKE '%mr. m%' > ---------------------------------------------------------- > There are no results for search by concated values, but expected 2: Max, > Mike. > > Regards, > Max > > -- > 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. > -- 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.
