bit field selection
| User, date | Message |
|---|---|
|
Written by Bogdan S
12 months 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
12 months 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
12 months ago 3954 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. |