Bug: default value incorrectly shown as b'' for actual values of b'0' and b'1'
When you select a table in heidiSQL, it shows the columns listed, including "Default" values. It shows these always as "" when they should be 0 or 1.
If you look at the "CREATE code", it shows:
`my_column` BIT(1) NOT NULL DEFAULT b'',
If you then do a pure sql:
show full columns from mytable
It shows: b'1' or b'0' correctly as the default.
Please login to leave a reply, or register at first.