Can't create a cpy of table with bit fields

14 posts
geoffschultz's profile image geoffschultz posted 3 years 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'.

6 posts
rednoise's profile image rednoise posted 3 years 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.