saving boolean values in SQLite

Question

I am kind of new to this. Whilst reading the sqlite documentation, it said that we boolean values cannot be in sqlite. I am really lost here so any help is appreciated. I am using a checkbox and I want to now how I can save that in sqlite

With this comment I want to refer to the people who just down vote without any explanation. Some people are just new and want to learn. If you have time to press that button, just try to spend few seconds more and give some proper explanation, except of or along with down voting, because this is the place where people just ask with the hope to get some clear answers, if possible! — X-HuMan, Jun 07 '16 at 14:56

score 1 · Accepted Answer · answered Jan 24 '15 at 16:29

1

SQLite does not have a separate Boolean storage class.

you can convert a boolean value to int and store in TINYINT(1) column type

data = booleanValue ? 1 : 0

answered Jan 24 '15 at 16:29

whiite

198
1
7

score 0 · Answer 2 · answered Jan 24 '15 at 16:27

0

1.1 Boolean Datatype

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

You should have read it to the end. See here

answered Jan 24 '15 at 16:27

Murat Karagöz

35,401
16
78
107

saving boolean values in SQLite

2 Answers2