Is there way to make sure that Sqlite3 will not commit other that intergers 0 and 1 to Boolean column

Asked Dec 06 '20 at 13:37

Active Dec 06 '20 at 13:37

Viewed 25 times

I am new to coding. I am trying to create table with one column being Boolean with Sqlite3 and Python. Sqlite site states that:

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

Is there way to make sure that when I am trying to commit an entry in the column it would not pass any other interger than 0 or 1? I fiugre that I can check this with a simple if statement (if interger > 1:), but I think it would be more beneficial if I could do that when I am creating the table so it would not be overlooked somehere else in my program, when it could potentialy make my table unusable.

asked Dec 06 '20 at 13:37

Heikki

see https://stackoverflow.com/questions/843780/store-boolean-value-in-sqlite – balderman Dec 06 '20 at 13:44
1

Specifically this answer: https://stackoverflow.com/a/22186315/10498828 – forpas Dec 06 '20 at 13:59

Is there way to make sure that Sqlite3 will not commit other that intergers 0 and 1 to Boolean column

0 Answers0