Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Is it possible to define bit column in sqlite? [duplicate]

Tags:

sqlite

sql-types

Sounds like a basic question but I couldn't seem to find it. Is there a way to define in SQLite a column which will be a single bit?

like image 618
user1908466 Avatar asked Dec 03 '13 12:12

user1908466

1 Answers

No.

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

Source

like image 196
juergen d Avatar answered Sep 19 '22 12:09

juergen d
Sign in to Comment

Related questions

Updating entity in EF Core application with SQLite gives DbUpdateConcurrencyException
Your target project 'XXX' doesn't reference EntityFramework. This package is required
How to use my own sqlite database?
SQLite multi process access
Good embedded database solution (like SQLite) for .Net
Android OrmLite pre-populate database
Python sqlite3 parameterized drop table
Use column name instead of number with sqlite3_column_text
Android and SQLite - retrieve max id from table
onUpgrade database - oldVersion - newVersion
bulk inserts with SQLite and CoreData
Can't open Sqlite database in read-only mode
Deploy a simple test app with Sinatra + DataMapper + Postgres + Heroku returns: Installing do_sqlite3 (0.10.7) error
Cannot create TEMP table in Android sqlite
How to Close Sqlite Connection without explicitly calling Close Method using .NET
Select at least one from each category?
Android search : Use FTS tables along with normal SQLite DB Tables
SQLite join in embedded database tables
sqlite3.DatabaseError: file is encrypted or is not a database
Search suggestions from different tables in different activities

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!