Hi,
I just found out all comparisons in MySQL are case insensitive. H2
also supports this mode (using "set ignorecase true"), however you
need to set it before creating any tables. I will document this.
Example:
drop table test;
set ignorecase true;
create table test(name varchar(255));
insert into test values('Hello');
select * from test where name like 'hello';
select * from test where name = 'hello';
select * from test where name regexp 'hello';
Regards,
Thomas
--
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.
