How I can implement bit data type in my table

Question

In my table student, there is a column attendance of BIT(1) data type. But when I do:

Insert into student values('False')

Mysql is giving error that data is too long but i have found in some article we can enter false and true in it. Also when I insert 1 or 0 and i try to print data on my screen:

Select * from student

It give some character like '?' as result. I need help in both of the queries.

Cid · Accepted Answer · 2019-06-25 10:04:43Z

1

'False' is string then try use the related bit value

 Insert into student values(0)

and if you need a decoded string as result

 select if(your_bit_column, 'True', 'False')

edited Jun 25, 2019 at 10:04

Cid

15.3k4 gold badges33 silver badges49 bronze badges

answered Jun 25, 2019 at 9:59

ScaisEdge

134k10 gold badges98 silver badges111 bronze badges

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

1 Comment

Cid Over a year ago

Insert into student values(false) should work too

Collectives™ on Stack Overflow

How I can implement bit data type in my table

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