How do I convert bit to string in MySQL?

Question

I have a bit field in a table and the data in the field looks like '0100' or '1100', etc. It is just a string of 1's and 0's. The type of the field in MySQL is 'BIT'. I need to read the data as a string. So I simply need to say:

select bit_field from mytable

but I need the bit field to come back as a string so I have tried

select CAST(bit as text) from mytable

but that throws an error. Also

select Convert(bit_field as UTF8) from mytable

returns the wrong type of data.

How can I accomplish this so that it returns bit_field as a string of text that looks like "0101" (or whatever is in the field)?

Shadow · Accepted Answer · 2016-03-03 18:24:52Z

8

I would use the export_set() function:

select export_set(bit_field,'1','0','',4) from mytable

answered Mar 3, 2016 at 18:24

Shadow

34.5k10 gold badges67 silver badges76 bronze badges

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

1 Comment

John Over a year ago

Excellent. Just what I needed. Thanks.

Collectives™ on Stack Overflow

How do I convert bit to string in MySQL?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related