distal-attribute
distal-attribute
distal-attribute
distal-attribute

bit field selection

Bogdan S posted 2 years ago in Feature discussion
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]
Bogdan S posted 2 years ago
Mixed up the links
http://dev.mysql.com/doc/refman/5.0/en/bit-field-literals.html
#
bug 2859
ansgar posted 2 years ago
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.

Please login to leave a reply, or register at first.