Unsigned Bit-Column

73 posts
[expired user #5151]'s profile image [expired user #5151] posted 11 years ago in General Permalink
I think, the "Unsigned"-option is not allowed at a BIT-column. If you check that option, a syntax-error is thrown.
I suggest to disable this option if BIT-datatype is selected (similar as done at VARCHAR, DATETIME, etc).
73 posts
[expired user #5151]'s profile image [expired user #5151] posted 11 years ago Permalink
Sorry for double-posting, but the same applies to "Zerofill".

Syntax:
BIT[(M)]

And on the contrary for example:
TINYINT[(M)] [UNSIGNED] [ZEROFILL]

Source: https://dev.mysql.com/doc/refman/5.0/en/numeric-type-overview.html
Code modification/commit ac3f8e2 from ansgar.becker, 11 years ago, revision 8.3.0.4750
Disable UNSIGNED and ZEROFILL checkboxes for BIT type columns. See http://www.heidisql.com/forum.php?t=15354
10361 posts
ansgar's profile image ansgar posted 11 years ago Permalink
Fixed in r4750
73 posts
[expired user #5151]'s profile image [expired user #5151] posted 11 years ago Permalink
Thx

Please login to leave a reply, or register at first.