Appropriate data field type for true/false value?

Question

What's the most appropriate (read least data consuming) data field to store a true/false/1/0 value in a mySQL database?

I have previously used a one character long tinyint, but I am not sure if it's the best solution?

Thanks!

possible duplicate of [Which MySQL Datatype to use for storing boolean values?](http://stackoverflow.com/questions/289727/which-mysql-datatype-to-use-for-storing-boolean-values) — plocks, May 11 '15 at 11:46

score 13 · Accepted Answer · edited May 23 '17 at 10:29

13

tinyint(1)

Is basically aliased from the BOOL data type so it is fine.

In addition, this has already been covered here:

edited May 23 '17 at 10:29

Community

answered Jun 07 '10 at 12:10

Bella

1 Answers1