|Subject||Re: [IBDI] Re: Internet|
> You say there is already a memo type field that supports LIKE ? What is itCurrently you can search contents of blobs by
> I read that setting the SUB_TYPE of a blob to text still does not support
> LIKE, was that article incorrect or is there another type I am unaware of ?
case sensitive LIKE and STARTING,
case in-sensitive CONTAINING.
Although search does not use indexes, it is pretty fast because
it is processed _after_ other conditions-optimized-by-indexes are applied.
The only problem is that blobs do not support collations -
it means that CONTAINING is in fact case in-sensitive for basic ASCII characters,
but case sensitive for national characters.