Subject Re: [firebird-support] Performing LIKE queries on a BLOB
Author Ivan Prenosil
> 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 to
> 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.