Size of a blob field in Firebird

firebird
pablo picture pablo · Jan 21, 2011 · Viewed 10.6k times · Source

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

bruno picture bruno · Jan 21, 2011

I think you can use the OCTET_LENGTH() function.

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

Related questions

Generate insert SQL statements from a CSV file

I need to import a csv file into Firebird and I've spent a couple of hours trying out some tools and none fit my needs. The main problem is that all the tools I've been trying like EMS Data Import …

Read More
Firebird error "username and password are not defined" with Delphi application

I have an application made with Delphi 2006 and Firebird 2.5. For connection a use Interbase components from Delphi. I setting up in design time a TIBDatabase with username, password tc, and work ok, but when i want to run application in …

Read More
Firebird x Windows 7 x gds32.dll error

I have a fdb file (firebird) from a new client (he doesn't know the version). I have tried to use some GUI to access the database, but with no luck. All of them tell that its missing gds32.dll, but …

Read More