distal-attribute
distal-attribute
distal-attribute
distal-attribute

How do define a bit field's default value in the GUI?

mbabcock_mslc posted 2 years ago in General
I can create a default value for a bit field in code, but I can't seem to do it in the GUI for creating/modifying table structures.

CREATE TABLE `test` (
`UserName` VARCHAR(50) NULL,
`ActiveFlag` BIT NOT NULL default b'1')

When I put in 1 or '1' or b'1' I keep getting "SQL Error (1067): Invalid default value for 'ActiveFlag'

How do I achieve this?

Thanks,
--Mike
jfalch posted 2 years ago
this is issue1979.
mbabcock_mslc posted 2 years ago
Thanks, jfalch. I noticed it was merged with 1160 (https://code.google.com/p/heidisql/issues/detail?id=1160) and I have clicked on the Star to add my vote for this being added/fixed.

Please login to leave a reply, or register at first.