I've got a Java application and also have planned a boolean area to a little(1) area in MySql.
I understand without a doubt that some rows possess the value set to true plus some to false, however, I can not view it in the mysql console - that is annoying whenever you attempt to debug things and understand what's going on.
Can you really configure mysql to show the part(1) fields inside a friendly manner?
mysql> choose overlooked from table +---------+ overlooked +---------+ +---------+ 10 rows in set (.00 sec)
select ignored+0 from table;
select cast(ignored as unsigned) from table;