SQLite Forum

Type of the column
Login
I recommend <u>[Datatypes in SQLite Version 3](https://sqlite.org/datatype3.html)</u> for your study. As you will find, among other facts, SQLite does store integers, tracking that they are integers. But it does not classify them by traditional, power-of-2 sizes, nor does it require you to do so. It uses the storage they need [a] as determined by how large the integer is, up to some value limit such as -2^63 to +2^63-1.

[a. The "need" is by how they fit in 1, 2, 3, 4, 6, or 8 bytes of storage. ]