sqlitesql-types

Is it possible to define bit column in sqlite?

Sounds like a basic question but I couldn't seem to find it. Is there a way to define in SQLite a column which will be a single bit?

Solution

  • No.

    SQLite does not have a separate Boolean storage class. Instead, Boolean values are stored as integers 0 (false) and 1 (true).

    Source