On 9 Jun 2018, at 4:49pm, Paul Sanderson <sandersonforens...@gmail.com> wrote:

> The serial types NULL, 0 and 1 each have a serial type 0, 8 & 9
> respectively and there is no data stored for the column - the content of
> the column is inherent in the serial types array.
> 
> Blobs and Strings with no content are serial types 12 & 13, and there is
> also zero bytes of data associated with each.

Do they not need a length indicator as well as the 12 or 13 ?  Oh, wait, I see. 
 The length indicator is stored in the same byte as the 12 or 13. Okay, please 
ignore my previous post.  It seems that storing blank strings is more efficient 
than I'd thought.

Thanks for the correction, Paul.

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to