Hi. I'm deciding between having several INTEGER fields and only one, which is a bit combination (i'd access it using e.g. main.bits&0x0011, main.bits&0x0100 and so on).
The docs say "INTEGER. The value is a signed integer, stored in 1, 2, 3, 4, 6, or 8 bytes depending on the magnitude of the value." So: which value is used to determine magnitude? Will the database size be larger if I use several fields (containing numbers smaller than e.g. 255) instead of a one bits field? Please, add this clarification to documentation. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
