Subject Re: [firebird-support] Containing in text blobs
Author Helen Borrie
At 07:35 AM 18/08/2006, you wrote:
>Hello,
>
>I thought I had in mind that searching text blobs (blob subtype 1) is
>only reliable for the first 1K of data.
>
>Maybe, I'm wrong.
>
>We did some tests today and could match a string even if it's position
>was after 2 MB within the blob data.
>
>So is there a limit?
>If yes, which one and depending on what...

There was a long-standing bug in blob searching, where a search
string would not be found if it was straddling the boundaries of two
blob segments. I know it has been fixed in Fb 2.0, just not certain
that it was backported to Fb 1.5.3....

Otherwise, I'm not aware of any limits - other than the old
traditional 64K "blob-end" limit that the BDE imposed on all blob
manipulation...

./heLen