HSQLDB LIKE query fails with sharp-s -

i'm unable write working query field containing german sharp-s (ß) in case-insensitive text field.

using hsqldb 2.2.9, create table case sensitive field , case insensitive field.

create cached table mytable (mykey longvarchar not null, primary key (mykey)); alter table mytable add column sen longvarchar; alter table mytable add column insen varchar_ignorecase; 

write 2 records.

insert mytable (mykey, sen, insen) values ('1', 'strauß', 'strauß'); insert mytable (mykey, sen, insen) values ('2', 'strauss', 'strauss'); 

verify.

select * mytable key, sen,       insen '1', 'strauß',  'strauß' '2', 'strauss', 'strauss' 

the problem query:

select * mytable insen '%ß%' wrong, returns record 2 not record 1 

these queries work expected:

select * mytable sen '%ß%' ok, returns record 1  select * mytable ucase(insen) '%ß%' ok, returns records 1 , 2  select * mytable ucase(sen) '%ß%' ok, returns nothing  select * mytable sen='strauß' ok, returns record 1  select * mytable insen='strauß' ok, returns record 1  select * mytable sen='strauss' ok, returns record 2  select * mytable insen='strauss' ok, returns record 2 

thanks!