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

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

User, date Message
Written by mbabcock_mslc
1 year ago
Category: General
7 posts since Thu, 01 Mar 12
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
Written by jfalchMoney, Euro
1 year ago
407 posts since Sat, 17 Oct 09
this is issue1979.
Written by mbabcock_mslc
1 year ago
7 posts since Thu, 01 Mar 12
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.