The integer type of SQLite

The integer in SQLite: A signed integer, depending on the size of the range in which the number is deposited, can be stored using 1,2,3,4,6,8 bytes depending on size.

In SQLite, there are also differences in storage classifications and data types, such as the integer storage category can contain 6 different lengths of integer data types, but once these integer data is read into memory, SQLite treats it all as a 8-byte unsigned integer.

INTEGER. The value is a signed integer, stored in 1, 2, 3, 4, 6, or 8 bytes depending on the magnitude of the value.

The integer storage class, for example, includes 6 different INTEGER datatypes of different lengths. This makes a difference on disk. But as soon as INTEGER values is read off of disk and into memory for processing, they is converted to the very general DataType (8-byte signed integer).

The maximum and minimum values for different lengths of integers are as follows:

Note that the Integer default is 4 bytes of int4.

Turn from:

http://zhiwei.li/text/2009/11/sqlite%E6%94%AF%E6%8C%81%E7%9A%84%E6%95%B0%E6%8D%AE%E7%B1%BB%E5%9E%8B/

Http://libdbi-drivers.sourceforge.net/docs/dbd_sqlite3/x123.html

The integer type of SQLite