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!
Comments
Post a Comment