bit field selection

if the field 'my_field' has type = bit, plain "select my_field from table" will auto append (to the end) zeros
so that 101 will become 10100000

to display correctly: "select BIN(my_field) from table"


[/url]
[url=http://code.google.com/p/heidisql/issues/detail?id=2859]

Mixed up the links
http://dev.mysql.com/doc/refman/5.0/en/bit-field-literals.html
#
bug 2859

This is not issue #2859, which is "reversed bit order".

If your BIT column is defined as BIT(8), than the appended zeros are ok, is it? If not, than you're right. I recall there was an issue report already for that but I can't find it right now.