Can't duplicate rows when table schema contains bit columns

Hello, since I updated to beta version duplicating rows (via ctrl+ins) that involve columns with bit data result in an SQL error. (eg: /* SQL Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 */)

It worked ok in version 6 stable.

Bye and thanks again for the awesome program~

There was never a working BIT support in HeidiSQL yet. But I'm now working on that, only bitmask calculation is driving me nuts. So I have committed the code now in r3823 which allows you to enter bit values like '01010111' into a grid cell, while the displayed values from the server sometimes are wrong.

For further discussion see issue #766

Wow looks like it's working now, i can even see values from server correctly! Thanks!!

Well most values seem right, but I have seen wrong ones too, so be carefull - this is not yet well tested.

By the way, you can see the server values compared to what HeidiSQL reads when firing:

SELECT bin(bitcolumn), bitcolumn FROM mytable

Oh ok i'll double check values when it's important stuff then!