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

bit field selection

User, date Message
Written by Bogdan S
2 years ago
Category: Feature discussion
2 posts since Thu, 31 May 12
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]
Written by Bogdan S
2 years ago
2 posts since Thu, 31 May 12
Mixed up the links
http://dev.mysql.com/doc/refman/5.0/en/bit-field-literals.html
#
bug 2859
Written by ansgar
2 years ago
5023 posts since Fri, 07 Apr 06
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.