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

[expired user #6261]'s profile image [expired user #6261] posted 11 years ago in General Permalink
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's profile image jfalch posted 11 years ago Permalink
this is issue1979.
[expired user #6261]'s profile image [expired user #6261] posted 11 years ago Permalink
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.