On 9 June 2018 at 16:17, Jay Kreibich <j...@kreibi.ch> wrote:

> Without digging through some detailed docs, I’m pretty sure empty string
> and NULL require the same amount of storage space.  If not, the difference
> is maybe one byte.
You are correct Jay

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.

SQLite Forensics Book <https://www.amazon.co.uk/dp/ASIN/1980293074>
sqlite-users mailing list

Reply via email to