How to store boolean values in SQLite

Question

I am currently designing a WPF application using a SQLite database. As part of this form, users are asked whether they have any disabilities and can check a couple of options in a list, such as No disability, Leg problems, heart issues etc. This will all go into a database that has a Student table. Currently my Student table SQL code is as follows:

CREATE TABLE STUDENT(
    StudentID int(5),
    firstName string(256),
    ...,
    age int(3)
);

The issue I am having is not knowing how to store this in the database. I know SQLite does not support Boolean values as this was my initial idea. If the box was selected then the value would be set to True and vice versa. In the absence of Boolean values, how would I go about storing this data in a database?

And I checked documentation for you. See [2.1. Boolean Datatype](https://www.sqlite.org/datatype3.html) section — Renatas M., Sep 05 '18 at 14:55
Possible duplicate of [Store boolean value in SQLite](https://stackoverflow.com/questions/843780/store-boolean-value-in-sqlite) — Ian, Sep 05 '18 at 15:01
Rather than age, you should store the DOB. In very short order the result of a calculation (like age) will be wrong and you wont be able to know how to update it — Ňɏssa Pøngjǣrdenlarp, Sep 05 '18 at 15:29
While strictly speaking SQLite doesnt have a Boolean, the NET Provider does so quite well. — Ňɏssa Pøngjǣrdenlarp, Sep 05 '18 at 18:37

score 2 · Answer 1 · answered Sep 05 '18 at 15:03

You can store boolean value in int(1) where 0 represent false and 1 - true.

See Data types in SQLite documentation there is separate section 2.1 Boolean Datatype:

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

score 1 · Answer 2 · answered Sep 05 '18 at 15:02

As you previously said, SQLite doesn't support BOOLEAN.

You have to store it as an INT.

1 will be TRUE

0 will be FALSE

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

You can check the documentation here

How to store boolean values in SQLite

2 Answers2