#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.

[Marc Delisle]

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.

[Marc Delisle]

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.

[Anonymous]

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.

[Marc Delisle]

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...