Quantcast

sqlite3_blob_bytes64() ?

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

sqlite3_blob_bytes64() ?

Olivier Mascia
Dear,

What is the purpose of sqlite3_bind_blob64() and sqlite3_bind_zeroblob64()?

The documentation says: "The current implementation will only support a string or BLOB length up to (2^31)-1 or 2147483647".
The default upper limit is even set lower (for good reasons) at 1 thousand millions.
And, quite rightly I think, there is no sqlite3_blob_size64().

--
Best Regards, Meilleures salutations, Met vriendelijke groeten,
Olivier Mascia, http://integral.software


_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: sqlite3_blob_bytes64() ?

Olivier Mascia
> Le 13 févr. 2017 à 23:23, Olivier Mascia <[hidden email]> a écrit :
>
> What is the purpose of sqlite3_bind_blob64() and sqlite3_bind_zeroblob64()?
>
> The documentation says: "The current implementation will only support a string or BLOB length up to (2^31)-1 or 2147483647".
> The default upper limit is even set lower (for good reasons) at 1 thousand millions.
> And, quite rightly I think, there is no sqlite3_blob_size64().

Maybe I should clarify it’s mainly bind_blob64() which puzzles me.
bind_zeroblob64() is different because it uses a rowid parameter that could be indeed of that magnitude.



--
Best Regards, Meilleures salutations, Met vriendelijke groeten,
Olivier Mascia, http://integral.software


_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: sqlite3_blob_bytes64() ?

Clemens Ladisch
In reply to this post by Olivier Mascia
Olivier Mascia wrote:
> What is the purpose of sqlite3_bind_blob64() and sqlite3_bind_zeroblob64()?

To allow 64-bit types (but not necessarily 64-bit values).  IIRC some
language binding needed this.


Regards,
Clemens
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: sqlite3_blob_bytes64() ?

Olivier Mascia
> Le 14 févr. 2017 à 12:46, Clemens Ladisch <[hidden email]> a écrit :
>
> Olivier Mascia wrote:
>> What is the purpose of sqlite3_bind_blob64() and sqlite3_bind_zeroblob64()?
>
> To allow 64-bit types (but not necessarily 64-bit values).  IIRC some
> language binding needed this.

Seems indeed the only logical reason.
Just a bit strange those same language bindings would have no use for a 64 bit sqlite3_blob_bytes64() though.
Anyway not important. Thanks!

--
Best Regards, Meilleures salutations, Met vriendelijke groeten,
Olivier Mascia, http://integral.software



_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Loading...