Hi, Sorry CHAR doesn't support IGNORECASE currently. The reason is I have expected nobody is really using CHAR except for compatibility. Why do you need CHAR?
However what works is using SET COLLATION: drop table test; set collation en strength primary; create table test(id int, name char); insert into test values(1, 'TEST'), (2, 'TEST '), (3, 'test'); select * from test where name='test'; select * from test where name='TEST'; Regards, Thomas On Mon, Jun 22, 2009 at 8:53 PM, Faw<fawzib.ro...@gmail.com> wrote: > > Another question, if I have in the same table the following: > > 'TEST ','TEST NAME',1 > > If I do the following: > > select * from clients where abbrname='TEST' > > It will also nothing as well, but > > select * from clients where RTRIM(abbrname)='TEST' > > will work. Is there a way to make char/varchar fields work the same > way as MS SQL? Ignore case and leading/trailing spaces? I think MYSQL > works the same way as well. > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to h2-database@googlegroups.com To unsubscribe from this group, send email to h2-database+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
