blobfirebird

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


Solution

  • I think you can use the OCTET_LENGTH() function.

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