> As long as your values are within the range of -128 to +127, your
> integers will only take one byte of storage (plus common overhead).
>
There's an extra byte of meta data for each column value in each
row due to manifest typing, so an int will take at least 2 bytes
of storage per column per row.
http://www.sqlite.org/fileformat.html#record_format
The exceptions are the special values 0 and 1 when using
pragma legacy_file_format=0;
then only 1 byte is required to store these values.
--
View this message in context:
http://www.nabble.com/How-to-bind-a-tinyint-so-that-actually-uses-1-byte--tp20147265p20152977.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users