Subject | Re: [firebird-support] querying blob size |
---|---|
Author | Ann W. Harrison |
Post date | 2007-04-24T20:37:26Z |
Puigsegur, Jordi wrote:
that return their length, the largest segment and a variety of
other interesting information. ISC_BLOB_INFO or something like
that.
Regards,
Ann
> Just a question on blobs:It's possible but not with SQL. There are info calls for blobs
>
> Is there a way to query the length of a blob in an sqlsentence?
>
> Something like:
> SELECT LEN(BLOB_FIELD) FROM MYTABLE;
>
that return their length, the largest segment and a variety of
other interesting information. ISC_BLOB_INFO or something like
that.
Regards,
Ann