sqlite3 boolean field storing text value

Asked Jan 17 '17 at 11:09

Active Jan 18 '17 at 05:14

Viewed 115 times

I dont know how the boolean data type column defined in sqlite3 is able to store a text type data.

I did this:

CREATE TABLE `sometable` (
    `name`  text,
    `bool_field` boolean
);

and ran the below insert query:

insert into `sometable` values ('name1','something');

and it worked like a charm without throwing any error. I am surprised - guys any idea why ? I know about the association of boolean field in sqlite3 is with numeric 1 and 0. but how come text getting stored here ?

Version Info:

SQLite Version 3.9.2

Used a client called "DB Browser for SQLite" for Ubuntu Version 3.7.0 (built on Qt version 5.5.1)

edited Jan 17 '17 at 12:04

asked Jan 17 '17 at 11:09

Dhwanit

Thanks GurV for the code edit :) – Dhwanit Jan 17 '17 at 11:13
What happens if you insert other string values, and if you select from the table? – jarlh Jan 17 '17 at 11:14
I tried with : select * from sometable; and it worked Even tried with : "insert into `sometable` values ('name1','something really huge');" and it works all the same – Dhwanit Jan 17 '17 at 11:20
And you get the same values back? Amazing. – jarlh Jan 17 '17 at 11:21
1

Yup I get the same values :) Quite surprising – Dhwanit Jan 17 '17 at 12:02

sqlite3 boolean field storing text value

0 Answers0