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.

Can not edit bit-columns

t3rk4l's profile image t3rk4l posted 2 weeks ago in Running SQL scripts Permalink

After updating to version 12.2.0.6581 I can not change data in columns of type bit. In the SQL-log the following statement is added

UPDATE test_db.shoporderitem SET SubscriptionCanceled=b0 WHERE ShopOrderItemId=27532;

And I get a message box with error: "SQL Error (1054): Unknown column 'b0' in field list" When my colleague changes the field in version 11.0.0.59.19 it works and the following statement is generated:

UPDATE test_db.shoporderitem SET SubscriptionCanceled=b'0' WHERE ShopOrderItemId=27532;

As you can see the value is different. Please look into this, thanks :)

Kind regards Terkel

1 attachment(s):
  • error1054
ansgar's profile image ansgar posted 2 weeks ago Permalink

Next build should fix that.

See also issue #1709.

Note that the recent versions have bugs in the build updater, so you might need to manually download the new build from the download page.

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.