MySQL default value of bit column

There is problem with default values of BIT columns.
If you set default value to 1, after saving changes HeidiSQL shows empty default value.
In phpMyAdmin the default value is displayed correctly.

Thanks for fixing me...
Keep sharing.



watson

I'm having this issue right now, what's the fix?

I'm having the same issue, all bit columns show default values b'' under CREATE code.

If you edit the column the code shows b'0' or b'1' correctly but upon saving it reverts back to b''

I forgot to add the version I was using, which was r4943

I just tested with 9.2 stable and it's broken as well: create tab shows a default value of b'' for bit columns and table editing does not work for those columns (sql error 1067: invalid default value for 'column name').

Exporting works fine tho, and produces the expected sql code with b'0' or b'1' as default values.

I have same problem. v 9.2.0.4960

Fixed in r4961. Works fine here. Please update your HeidiSQL to the latest build and report back if that works for you too.

It does work for me now, thanks!

I have installed r4961 and now it works as expected. Thank you.

Dears,

Thank you so much! problem fixed in r4961!