poohdedoo
Reputation: 1268
What is the best data type to store boolean values in a database
What is the best data type to store boolean values in a database? which is supported by mostly used RDBMS types such as Mysql,oracle,postgres,mssql
Upvotes: 3
Views: 6905
Answers (2)
user330315
Reputation:
If the DBMS supports a real boolean type (e.g. PostgreSQL) then use that. If it doesn't I usually prefer an integer value combined with a check constraint that ensures that only 0 and 1 can be stored. In my experience it also makes sense to define the column as NOT NULL as well. Having a NULL value for a boolean is always somewhat confusing.
You won't find a single datatype that works for all DBMS. I would always use the "best" one that the DBMS offers.
Upvotes: 2
Related Questions
- Which MySQL data type to use for storing boolean values
- MySql - Which column type to use for storing multiple booleans in multiple columns?
- is it practical to use bit data type to store true/false into sql database?
- db best practices: data + boolean column or just data?
- which is best data type to store booelan values in postgresql in comparision with less memory?
- Are there reasons for not storing boolean values in SQL as bit data types?
- sql boolean datatype alternatives
- What to use when not using Boolean type?
- which data type i must choose for boolean type field?
- Database Table of Boolean Values