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. Paul www.sandersonforensics.com SQLite Forensics Book <https://www.amazon.co.uk/dp/ASIN/1980293074> _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users