Dealing with data types in sql tables

Question

Which data type is recommended to use for a field that only stores a boolean value (for example status of a user)?

In my case is as following:

...
disabled tinyint(1) DEFAULT '0' NOT NULL
...

Is there a performance difference between tinyint(1) and int(11) ?

You could use the BIT datatype to represent boolean data in sql server — saravanatn, Jun 27 '18 at 12:29
Check this: https://dev.mysql.com/doc/refman/8.0/en/storage-requirements.html — Mayank Pandeyz, Jun 27 '18 at 12:33

score 2 · Accepted Answer · answered Jun 27 '18 at 12:33

2

I would go about using bit since it stores a 0 or 1 aka false or true

answered Jun 27 '18 at 12:33

t..

1 Answers1