MySQLBOOL 和 BOOLEAN 列数据类型之间的区别是什么？

小开

最佳答案

They are both synonyms for TINYINT(1).

小开

check the MySQL docs overview of numeric types:

http://dev.mysql.com/doc/refman/5.0/en/numeric-type-overview.html

小开

One thing I just noticed - with a column defined as BOOL in MySql, Spring Roo correctly generates Java code to unmarshall the value to a Boolean, so presumably specifying BOOL can add some value, even if it's only in the nature of a hint about the intended use of the column.

小开

As established in other comments, they're synonyms for TINYINT(1).

*So, why do they bother differentiating between bool, boolean, tiny*int(1)?

Mostly semantics.

Bool and Boolean: MySQL default converts these to the tinyint type. Per a MySQL statement made around the time of this writing, "We intend to implement full boolean type handling, in accordance with standard SQL, in a future MySQL release."

0 = FALSE 1 = TRUE

TINYINT: Occupies one byte; ranges from -128 to +127; or, 0 – 256.

Commonly brought up in this comparison: After MySQL 5.0.3 -- Bit: Uses 8 bytes and stores only binary data.