mysqlintegerstoragetinyintdatafield

Appropriate data field type for true/false value?

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!

Solution 
  • tinyint(1)

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

    See here

    In addition, this has already been covered here:

    Which MySQL data type to use for storing boolean values