Subject | Re: [firebird-support] Performing LIKE queries on a BLOB |
---|---|
Author | Ivan Prenosil |
Post date | 2003-10-06T00:32:45Z |
> Hmmmm...maybe one day when the crazy days of my current project haveThere are several solutions. E.g.
> 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.
- Use UDF instead of LIKE operator
- Use streamed blobs instead of segmented ones.
Ivan