Size of a blob field in Firebird

Question

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 to know the total size of all the records in the table.

Thanks.

score 13 · Accepted Answer · edited May 23 '17 at 12:00

13

I think you can use the OCTET_LENGTH() function.

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

edited May 23 '17 at 12:00

Community

answered Jan 21 '11 at 15:07

bruno

score 2 · Answer 2 · answered Jan 21 '11 at 19:42

2

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

answered Jan 21 '11 at 19:42

José Romero

What is better F_BLOBSIZE or OCTET_LENGTH? – hellboy Oct 10 '13 at 11:31
@hellboy: OCTET_LENGTH for Firebird 2.1 and up, F_BLOBSIZE for Firebird 2.0 and below. See [the Firebird documentation](http://www.firebirdsql.org/refdocs/langrefupd21-intfunc-octet_length.html) for more details – alldayremix Dec 31 '15 at 17:39

2 Answers2