Isn't this what you are looking for?
http://www.sqlite.org/capi3ref.html#sqlite3_column_bytes
" If the result is a BLOB then the sqlite3_column_bytes() routine returns
the number of bytes in that BLOB. "
Or do you really need it inside an SQL statement?
Rob
----- Original Message -----
From: "Lloyd Dupont" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Sunday, October 23, 2005 3:15 PM
Subject: [sqlite] built-in functrion suggestion: size of blob
I look into the build in function of SQLite and saw there is a function to
know the length of a string (in a record).
Great!
But to my disbelief there is (apparently) no way to get the size of a blob
(other than loading it :-()
And no, length() doesn't work on Blob.
I think it would be a worthy addition!
Or is there already an (undocumented) such addition?
