Menu
▾
▴
#1171 (ok 3.3) use standard BOOLEAN data type
Relates to:
https://sourceforge.net/tracker/index.php?func=detail&aid=1177459&group_id=23067&atid=377411
The BOOL keyword is secondary to BOOLEAN. BOOLEAN is the primary keyword. BOOLEAN is standard SQL, BOOL is not. I know of no other DBMS that uses BOOL as a type.
Please change BOOL to BOOLEAN on any occurrence.
PS: I couldn't figure out the right category.
Discussion
I don't see in http://dev.mysql.com/doc/refman/5.1/en/numeric-type-overview.html
that BOOL is secondary to BOOLEAN. And please, this is a bug? Come on....
It might be seen as an improvement, though.
Also, this is configurable in your config.inc.php, just take the $cfg['ColumnTypes'] and $cfg['RestrictColumnTypes'] of libraries/config.default.php and change BOOL to BOOLEAN.
As I said, BOOLEAN is standard SQL, BOOL isn't. You're right, it's just a minor improvement. You should fix this anyway because of that reason. No other DBMS uses BOOL.
Changed for version 3.3. Please note that there are plenty occasions where MySQL is deviant compared to standard SQL; I just hope we won't get complaints to put back BOOL...