| Subject | Re: [ib-support] containing is case sensitive for g erman chars ä ü ö in text blobs |
|---|---|
| Author | Ivan Prenosil |
| Post date | 2002-11-29T10:24:41Z |
> select * from TABLE where VARCHARCOLUMN containing 'ä' returns rowsThe reason is that blobs allow specifying character set, but not collation.
> 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 ?No, just missing feature.
As a workaround you can write UDF for performing full case insensitive search in blobs.
Ivan
http://www.volny.cz/iprenosil/interbase