I need to insert BOOL
value into SQLite table. If you have any thoughts开发者_如何学JAVA, or sample code please share.
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).
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
精彩评论