SQLite Data Types

SQLite supports various data types, and this page provides a compilation of commonly used data types in SQLite.

  1. BLOB

    In SQLite, the BLOB data type is used to store binary data.

  2. INTEGER

    In SQLite, the INTEGER data type is used to store integer values.

  3. NULL

    In SQLite, the NULL data type is used to represent a missing or unknown value.

  4. NUMERIC

    In SQLite, the NUMERIC data type is used to store numbers with variable precision.

  5. REAL

    REAL is a data type in SQLite used to store floating-point numbers, which are numbers with a decimal point.

  6. TEXT

    TEXT is a data type in SQLite used for storing text strings.