Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SQLite inserting bool value

I need to insert BOOL value into SQLite table. If you have any thoughts, or sample code please share.

like image 283
LightNight Avatar asked Sep 06 '11 08:09

LightNight


2 Answers

From http://www.sqlite.org/datatype3.html:

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

like image 184
Oliver Charlesworth Avatar answered Oct 25 '22 03:10

Oliver Charlesworth


SQLite can recognize the BOOL as a type, however it is stored as an integer rightfully mentioned by Oli Charlesworth.

However using the BOOL keyword would still work:

CREATE TABLE YourTable(
    isBool   BOOL NOT NULL DEFAULT 0,
);

INSERT INTO YourTable (isBool) VALUES (1);
INSERT INTO YourTable (isBool) VALUES (4);

SELECT * FROM YourTable;

isBool    
----------
1         
4 

4 would still be added to YourTable

like image 31
apouche Avatar answered Oct 25 '22 03:10

apouche