Subject | Re: Streamed Blob |
---|---|
Author | Roman Rokytskyy |
Post date | 2003-10-06T11:35:51Z |
> Are streamed blobs a possibility when using JayBird? I cannot reliablyYes, current version of JayBird in CVS uses stream blobs by default
> use LIKE queries that contain wild cards with a segmented blob. The
> wild card breaks if it goes across a segment boundary. For example, if
> I select LIKE "%line2%line200%" and the blob segments on say line 50,
> the query will fail.
(and probably using segemented blobs needs recompilation :)). But as
long as your blob was created segmented, you cannot switch it to
streamed and vice versa. So, if your test works in IBExpert with the
same blob it fails in JayBird, then something wrong is somewhere else.
Roman