SQLite3

this storage class is used to store any NULL value.

NULL

any numeric value is stored as a signed integer value (It can hold both positive and negative integer values). 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.

INTEGER

this storage class is used to store the floating point values, and they are stored in an 8-bytes of storage.

REAL

stores text strings. It also supports different encoding like UTF-8, UTF-16 BE, or UTF-26LE.

TEXT

used to store large files, like images or text files. The value is stored as byte array the same as the input value.

BLOB

Affinity types:

TEXT. NUMERIC. INTEGER. REAL. BLOB.