What's the difference between MySQL BOOL and BOOLEAN column data types?

mysql sqldatatypes
ikostia picture ikostia · Jan 21, 2011 · Viewed 46.3k times · Source

I'm using MySQL version 5.1.49-1ubuntu8.1. It allows me to define columns of two different data types: BOOL and BOOLEAN. What are the differences between the two types?

Answer

Adam Prax picture Adam Prax · Jan 21, 2011

They are both synonyms for TINYINT(1).

Related questions

Should I use the datetime or timestamp data type in MySQL?

Would you recommend using a datetime or a timestamp field, and why (using MySQL)? I'm working with PHP on the server side.

Read More
Which MySQL data type to use for storing boolean values

Since MySQL doesn't seem to have any 'boolean' data type, which data type do you 'abuse' for storing true/false information in MySQL? Especially in the context of writing and reading from/to a PHP script. Over time I have …

Read More
Best data type to store money values in MySQL

I want to store many records in a MySQL database. All of them contains money values. But I don't know how many digits will be inserted for each one. Which data type do I have to use for this purpose? …

Read More