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.

Bug: default value incorrectly shown as b'' for actual values of b'0' and b'1'

eos's profile image eos posted 7 years ago in General Permalink
Applies to type of BIT(1). This is used extensively by grails to represent booleans.

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.




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.