Bug #20281 impossible to update records with bit colum
Submitted: 6 Jun 2006 6:31 Modified: 19 Dec 2006 13:49
Reporter: Ralf Hauser Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.1.20 OS:Windows (WinXP)
Assigned to: Mike Lischke CPU Architecture:Any
Tags: Result Set

[6 Jun 2006 6:31] Ralf Hauser 
Description:
as per bug #15511 where I cannot add a screen-shot  :(

How to repeat:
edit it

Suggested fix:
toggle or checkbox
[6 Jun 2006 6:32] Ralf Hauser 
BIT_typeRowUpdateViaQB.png

Attachment: BIT_typeRowUpdateViaQB.png (image/png, text), 67.94 KiB.
[6 Jun 2006 6:52] Valeriy Kravchuk 
Thank you for a bug report. Verified just as described. There is no way to edit BIT columns value successfully. Error 1406 is a result even for reasonable values of 0 and 1, that can be INSERTed using command line mysql interface.
[19 Dec 2006 13:49] Mike Lischke 
Thank you for your bug report. This issue has already been fixed in the latest released version of that product, which you can download at

  http://www.mysql.com/downloads/
[1 Aug 2008 17:22] Glen Ainscow 
Mike,

Which version are you referring to? I have the latest (1.2.12), and I still can't update a BIT column.

Glen.