Explain How Boolean Values In Sqlite Are Stored? – InterviewSolution

InterviewSolution

1.

Explain How Boolean Values In Sqlite Are Stored?

Answer»

Boolean VALUES in SQLite are stored as integers 0 (false) and 1 (true). SQLite does not have a separate Boolean STORAGE class.

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

Discussion

No Comment Found

Related InterviewSolutions

I Accidentally Deleted Some Important Information From My Sqlite Database. How Can I Recover It?
What Is An Sqlite_corrupt Error? What Does It Mean For The Database To Be "malformed"? Why Am I Getting This Error?
Does Sqlite Support Foreign Keys?
The Sql Standard Requires That A Unique Constraint Be Enforced Even If One Or More Of The Columns In The Constraint Are Null, But Sqlite Does Not Do This. Isn't That A Bug?
What Is The Export Control Classification Number (eccn) For Sqlite?
My Query Does Not Return The Column Name That I Expect. Is This A Bug?
Insert Is Really Slow - I Can Only Do Few Dozen Inserts Per Second?
Case-insensitive Matching Of Unicode Characters Does Not Work?
Why Does Round(9.95,1) Return 9.9 Instead Of 10.0? Shouldn't 9.95 Round Up?
What Is An Sqlite_schema Error, And Why Am I Getting One?