The built-in Sqlite length() function works just fine on blobs:
sqlite> select length(X'0000000000');
5
Why do you think it doesn't?
--- Lloyd Dupont <[EMAIL PROTECTED]> wrote:
> 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?
__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com
