Bug #44513 Data type BIT
Submitted: 28 Apr 2009 12:28 Modified: 28 May 2009 12:48
Reporter: Fernanda Franhan Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Data Types Severity:S3 (Non-critical)
Version:5.1.33 OS:Windows
Assigned to: CPU Architecture:Any

[28 Apr 2009 12:28] Fernanda Franhan
Description:
Mysql 5.1.33 when selecting tables that possess fields of the type BIT, just appears a " b " and it is not possible to identify what is false and what is true.  
  
Thank you

How to repeat:
-
[28 Apr 2009 12:48] Valeriy Kravchuk
Please, read the manual about BIT datatype, http://dev.mysql.com/doc/refman/5.1/en/numeric-types.html. Try to select HEX(bit_column) to see the value stored, not character with the corresponding code.

If you still think there is a bug, please, send complete, repeatable test case.
[28 May 2009 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".