Subject RE: [firebird-support] Performing LIKE queries on a BLOB
Author Robert DiFalco
I think the problem is that the string function is segmented on a blob
field (even for stream blobs). It looks like the blob is streamed-in in
chunks of 1K and the matching algorithm is only inclusive to that 1K
block. So, I don't think using a stream blob will help.

A UDF would probably work fine. Does anyone here know if there is a UDF
library that performs a simple LIKE matching function on text blobs
(i.e. '%' and '_') that works on Windows and Solaris?


-----Original Message-----
From: Ivan Prenosil [mailto:Ivan.Prenosil@...]
Sent: Sunday, October 05, 2003 5:33 PM
Subject: Re: [firebird-support] Performing LIKE queries on a BLOB

> Hmmmm...maybe one day when the crazy days of my current project have
> ended I can take a look at the FB source. Seems like I should be able
> buffer all the data in segment by segment or use a streaming blob to
> prevent the wild-card matching from failing when crossing segment
> boundaries. For now, there really is no solution.

There are several solutions. E.g.

- Use UDF instead of LIKE operator

- Use streamed blobs instead of segmented ones.


Yahoo! Groups Sponsor

To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.