On 24 Jul 2013, at 12:04am, j.merr...@enlyton.com wrote: > I do not know if SQLite has the storage behavior that e.g. PostgreSQL and MS > SQL Server have, which is that null values take up absolutely no space.
SQLite uses a one-byte 'type' indicator, followed by some bytes for the value. The 'type' tells SQLite how many bytes to expect for the value. The NULL type indicates that zero bytes follow. So it uses one byte per NULL value. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
