Bug #30005 Not possible to set a value for a bit value
Submitted: 24 Jul 2007 11:45 Modified: 28 May 2009 12:41
Reporter: Wolfgang Purrer Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Query Browser Severity:S2 (Serious)
Version:1.2.12 OS:Windows (XP SP2)
Assigned to: CPU Architecture:Any
Tags: bit

[24 Jul 2007 11:45] Wolfgang Purrer 
Description:
If I have a table where one column is a bit value, and I want to add one row in the edit - mode.

The the Query Browser writes down:

"Data too long for column '<column - name>' at row 1"

If I enter a row with the insert command and select the data afterwards.
The bit column is shown as b'1'

If I try to enter a second row with b'1' or '1'

the following message appear
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1'')' at line 1

How to repeat:
create a table with a bit column.

Open query browser

try to set the value of the column to true or 1
[24 Jul 2007 12:38] MySQL Verification Team 
Thank you for the bug report.
[25 Jul 2007 18:34] Ralf Hauser 
see also Bug #20281
[14 Jan 2009 2:45] Mike Hoeffner 
See all Bug 28630
[28 May 2009 12:41] Susanne Ebrecht 
This is a duplicate of bug #28630