Subject | containing is case sensitive for german chars ä ü ö in text blobs |
---|---|
Author | zipzipziping |
Post date | 2002-11-28T18:47:53Z |
hi,
i have the problem with selecting rows from a table with a text blob.
charset WIN1252
firebird 1.0
containing is not case sensitive, but not for german chars ä ü ö in
text blobs. in varchar columns it works correct.
select * from TABLE where VARCHARCOLUMN containing 'ä' returns rows
with ä and Ä. this is how it should be.
select * from TABLE where BLOBTEXT containing 'ä' returns rows
with only with ä and not with Ä. this is how it not should be.
is this a bug ?
thanks for your help
i have the problem with selecting rows from a table with a text blob.
charset WIN1252
firebird 1.0
containing is not case sensitive, but not for german chars ä ü ö in
text blobs. in varchar columns it works correct.
select * from TABLE where VARCHARCOLUMN containing 'ä' returns rows
with ä and Ä. this is how it should be.
select * from TABLE where BLOBTEXT containing 'ä' returns rows
with only with ä and not with Ä. this is how it not should be.
is this a bug ?
thanks for your help