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.

Answer 1

I think you can use the OCTET_LENGTH() function.

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