Menu
Does SQLite require you to mention field size or are there fixed size for each DataType
ID INTEGER (10)
ID INTEGER
269
The INTEGER values in SQLite are stored in either 1, 2, 3, 4, 6, or 8 bytes of storage depending on the value of the number.
However, the dynamic typing in SQLite allows it to do things which are not possible in traditional rigidly typed databases. So in MS Sql Server (for example), an "int" == "integer" == 4 bytes/32 bits. In contrast, a SqlLite "integer" can hold whatever you put into it: from a 1-byte char to an 8-byte long long.
The value is a signed integer, stored in 1, 2, 3, 4, 6, or 8 bytes depending on the magnitude of the value. Since long is 8 byte and INTEGER can also save values of 8 bytes, you can use INTEGER .
You can query the database with these two: pragma page_size; pragma page_count; (see the sqlite pragma docs). Multiply the first by the second and you'll get total pages used.
each datatype have fixed size. for more details check http://www.sqlite.org/datatype3.html
160
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
