Kevin Burton wrote:
A little birdie:
http://forge.mysql.com/wiki/Top10SQLPerformanceTips
notes......
"In 5.1 BOOL/BIT NOT NULL type is 1 bit, in previous versions it's 1 byte."
Is this true?
Hmm, I had wondered about that when someone yelled it out at MySQL Camp...
No, it's not true. The BIT data type is not the same as BOOL. BIT is
used for easier bitmask/bitfield type columns, and BOOL is used for
boolean values, but it is currently aliased to TINYINT(1). So, this is
patently false.
True boolean data type support is, however, planned for a future
release...not sure when though.
I'll remove that from the wiki page.
Cheers,
Jay
I didn't see a note in the manual......
I assume it would be here....
http://dev.mysql.com/doc/refman/5.1/en/storage-requirements.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
