Subject | RE: [firebird-support] Performing LIKE queries on a BLOB |
---|---|
Author | Robert DiFalco |
Post date | 2003-10-06T02:17:46Z |
Can you refer me to info on stream blobs? I can find how to define them
in DDL. I always end up with segmented blobs.
-----Original Message-----
From: Ivan Prenosil [mailto:Ivan.Prenosil@...]
Sent: Sunday, October 05, 2003 5:33 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Performing LIKE queries on a BLOB
- Use UDF instead of LIKE operator
- Use streamed blobs instead of segmented ones.
Ivan
Yahoo! Groups Sponsor
ADVERTISEMENT
To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
in DDL. I always end up with segmented blobs.
-----Original Message-----
From: Ivan Prenosil [mailto:Ivan.Prenosil@...]
Sent: Sunday, October 05, 2003 5:33 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Performing LIKE queries on a BLOB
> Hmmmm...maybe one day when the crazy days of my current project haveto
> 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 toThere are several solutions. E.g.
> 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
Yahoo! Groups Sponsor
ADVERTISEMENT
To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.