I have the following table:
CREATE TABLE CLIENTS(
ABBRNAME CHAR(32) NOT NULL,
NAME CHAR(80) NOT NULL,
CLIENTNO SMALLINT NOT NULL,
PRIMARY KEY( ABBRNAME , CLIENTNO )
);
with the following data:
'TEST','TEST NAME',1
I created the database with the IGNORECASE=TRUE and also tried the SET
IGNORECASE TRUE command.
If I do the following:
select * from clients where abbrname='test'
it will return nothing. I think its because it's a CHAR field. Does
the IGNORECASE only works on VARCHAR fields? Why not on CHAR?
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
