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!

Bunton

possible duplicate of Which MySQL Datatype to use for storing boolean values? – Goldeneye

Answer 1

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

Cabinet