SQLite Data Types

In Version 3:

Null:

INTEGER:

REAL:

TEXT:

BLOB:

No Boolean type.

No Date and Time type, but the build-in Date and Time function could store Date and Time as TEXT, REAL or Integer.

TEXT as ISO8601 Strings (YYYY-MM-DD HH:MM:SS.SSS)

REAL

INTEGER