Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Unsigned Bit-Column

Plasm's profile image Plasm posted 7 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).
Plasm's profile image Plasm posted 7 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 from ansgar.becker, 7 years ago, revision 4750
Disable UNSIGNED and ZEROFILL checkboxes for BIT type columns. See http://www.heidisql.com/forum.php?t=15354
ansgar's profile image ansgar posted 7 years ago Permalink
Fixed in r4750
Plasm's profile image Plasm posted 7 years ago Permalink
Thx

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




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.