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't create a cpy of table with bit fields

geoffschultz's profile image geoffschultz posted 6 months ago in General Permalink

I have a table with bit fields in it. When I right-click on the table and do a Create New -> Table Copy, I get the error: "SQL error (1067): Invalid default value for field xyz". The default value is b'1'.

rednoise's profile image rednoise posted 1 month ago Permalink

I have the same bug since always. It also happens when I modify a table containing bit columns.

I think it is a problem on how heidisql adds escape character (b'0' => 'b\'0\'').

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.