Alan McDonald wrote:

>>> Prior to v2.1, SUBSTRING(BLOB) returned a varchar, but now it returns
>>> a temporary blob. So I believe the blob contents is actually fetched
>>> by the client via the blob ID. Could it be possible that it's done
>>> after a transaction commit, for example?
>
> when I query the view with substring, I get no such blob chatter.

If this has something to do with the resulting blob, could a possible
workaround be:

CAST(SUBSTRING(MyBlob FROM 1 FOR 250) as VARCHAR(250))

I've no idea about the cause of your problem, nor whether the problem is
with Firebird or IBO.

Set