Hi, The option "ignorecase=true" will convert all column that are created as "varchar" to "varchar_ignorecase". I think the problem is that text literals are still interpreted as varchar, not varchar_ignorecase, so that if you compare text literals with other text literals, this is still case sensitive. The following works as expected (1 result for each query):
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%'; I guess one solution would be to convert text literals to varchar_ignorecase when using the ignorecase option. I hope this doesn't break existing applications. > The real scenario is related to CONCAT result. Could you describe the real scenario please? Regards, Thomas On Wed, Oct 30, 2013 at 10:30 AM, Max Sidnin <[email protected]> wrote: > H2 version is 1.3.174 > > Full connection string > is: > ;LOG=1;MVCC=TRUE;PAGE_SIZE=16384;CACHE_TYPE=TQ;ALIAS_COLUMN_NAME=TRUE;IGNORECASE=TRUE;MAX_MEMORY_ROWS=100000;DB_CLOSE_DELAY=0;CIPHER=AES;CACHE_SIZE=40000;MAX_OPERATION_MEMORY=20000000; > > -- > 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.
