Subject Re: [firebird-support] querying blob size
Author Ann W. Harrison
Puigsegur, Jordi wrote:
> Just a question on blobs:
>
> Is there a way to query the length of a blob in an sqlsentence?
>
> Something like:
> SELECT LEN(BLOB_FIELD) FROM MYTABLE;
>

It's possible but not with SQL. There are info calls for blobs
that return their length, the largest segment and a variety of
other interesting information. ISC_BLOB_INFO or something like
that.

Regards,


Ann