Size of a blob field in Firebird

Is there a way to retrieve (using a select statement) the size of a blob field in Firebird??

I've a field called "data" and I'd like t开发者_StackOverflowo know the total size of all the records in the table.

Thanks.

---

I think you can use the OCTET_LENGTH() function.

You should also look at this answer it should be helpful.

---

If the field contains Images or another kind of data or even Text, you can use F_BLOBSIZE(blobfield) from FreeAdHocUDF

Input BLOB TextBLOb For TextBLOb: returns the size/length (similar F_STRINGLENGTH) For BinarBLOb: returns the size of file in byte