Processing BIT data "\x0\x0\x0\x0\x0\x0\x0\x5"
Posted: Mon Oct 19, 2009 5:42 am
I have setup a BIT(64) field in MYSQL.
I can populate this field OK converting the flags "0000000000000000000000000000000000000000000000000000000000000101", but when the data is returned in a query it is represented as "\x0\x0\x0\x0\x0\x0\x0\x5" and I can't find any hints online how to convert this back to flags....
I've pulled out what little hair I had left, threw my arms in the air and post this plea for HELP!!
I know you are going to say 'why?', but I'm not looking for criticism, just an answer...
p.s. I'm a mainframe COBOL programmer and all this php stuff is a bit foreign...
I can populate this field OK converting the flags "0000000000000000000000000000000000000000000000000000000000000101", but when the data is returned in a query it is represented as "\x0\x0\x0\x0\x0\x0\x0\x5" and I can't find any hints online how to convert this back to flags....
I've pulled out what little hair I had left, threw my arms in the air and post this plea for HELP!!
I know you are going to say 'why?', but I'm not looking for criticism, just an answer...
p.s. I'm a mainframe COBOL programmer and all this php stuff is a bit foreign...