SELECT mysql SET column as BIT STRING?

Question

Whenever I try:

SELECT column1 FROM table1;

I get results as comma separated strings (column1 is of type SET):

'result4,result7,result24'
'result2,result15,result36'

etc...

Since mysql SET type is just a 64 BIT string AFAIK - how would I get values as bit string / bit mask?

SELECT function_that_converts_to_bit_string( column1 ) FROM table1;

So result would be:

100100101110000101110
101000110110000101110
100001111100110001110
...

Barmar · Accepted Answer · 2012-09-07 19:03:04Z

1

select bin(cast(column1 as decimal)) from table1;

edited Sep 7, 2012 at 19:03

answered Sep 7, 2012 at 18:57

Barmar

789k57 gold badges554 silver badges669 bronze badges

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

2 Comments

Barmar Over a year ago

I tried it at SQLfiddle and it displayed numbers, although they were in decimal. But I just edited it to display in binary.

zzz Over a year ago

YES. this works great. SELECT BIN(column1+0) from table1;. THANKS!

EffectiX · Accepted Answer · 2012-09-07 18:56:44Z

0

What is the datatype and collation for column1?

There is a binary datatype (BINARY itself or BLOB) that you can use to get binary data like so. Also the collation should be set to anything (latin1, utf-8 etc.)-bin The binary collation from whatever collation set you are using, instead of case insensitive (-ci) or case sensitive (-cs) variants.

answered Sep 7, 2012 at 18:56

EffectiX

3162 silver badges6 bronze badges

3 Comments

EffectiX Over a year ago

apologies, I didn't see it in the OP... how about the collation?

zzz Over a year ago

utf8-general-ci ... alhough - not sure if that's relevant for set type.

EffectiX Over a year ago

I think it is relevant if you want to get binary data out of it. The query posted by Barmar should work if you change your collation to utf8-bin

Collectives™ on Stack Overflow

SELECT mysql SET column as BIT STRING?

2 Answers 2

2 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related