problem with bit in mysql

Question

resultset = statemet.executequery("select shift+0 from sportman");

string x = resultset.getstring("shift");

but second line throw exception:

Column 'shift' not found.

shift is bit(8) and i want to show it to form '000101'.

yes but it returned for example 45 but i want it was in the form of 01010 — Mahdi_Nine
– Mahdi_Nine, Commented May 1, 2011 at 7:32

sjr · Accepted Answer · 2011-05-01 07:42:21Z

1

Integer.toBinaryString(Integer.valueOf(resultset.getString("shift+0")))

Result is not zero-padded to the width you want though. You may need to add that yourself later.

answered May 1, 2011 at 7:42

sjr

9,9151 gold badge27 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1