RMySQL Bit(1) is read incorrectly

Bit(1) is read incorrectly

Open mauricewendt opened this issue 8 years ago • 2 comments

I am using RMySQL 0.10.9 and Bit(1) columns are returned as 0, but there are all 1

Sep 20 '16 10:09 mauricewendt

Yes, this is a known behavior. You can use SELECT IF( field, 1, 0 ) AS field FROM table.

Sep 29 '16 15:09 karina-rebuli

Are there any plans for fixing this in the near future?

Dec 22 '16 14:12 emillykkejensen