MySQL always returning BIT values as blank

mysql sqldatatypes

You need to cast the bit field to an integer.

mysql> select hasMultipleColors+0 from pumps where id = 1;

This is because of a bug, see: http://bugs.mysql.com/bug.php?id=43670. The status says: Won't fix.

mysql sqldatatypes

You can cast BIT field to unsigned.

  SELECT CAST(hasMultipleColors AS UNSIGNED) AS hasMultipleColors   FROM pumps   WHERE id = 1

It will return 1 or 0 based on the value of hasMultipleColors.

mysql sqldatatypes

You need to perform a conversion as bit 1 is not printable.

SELECT hasMultipleColors+0 from pumps where id = 1;

CodeHunter