How to update the table value field which type is bit using mybatis in mysql?

Question

I have a table called tbStudent. When I set the sex field using integers, and pass the parameter value in as 1 or 0 , it works just fine. But now,when I try to update the sex field type using bits, and also pass the parameter value in as 1 or 0 , it does not work correctly. I try to pass the parameter value in as true or false ,but it still does not work as intended. How to fix it so that it will work with bits? The error is:

//I only pass in the value 1, why does it say too long?
Data truncation: Data too long for column 'SEX' at row 1;
nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: 
Data too long for column 'SEX' at row 1

what is the datatype of sex in pojo class?? – Prasanna Kumar H A May 11 '16 at 06:47 — Prasanna Kumar H A, May 11 '16 at 06:47

score 2 · Answer 1 · answered May 10 '16 at 18:35

2

try inserting as b'1' or b'0' source: http://dev.mysql.com/doc/refman/5.0/en/bit-field-literals.html

answered May 10 '16 at 18:35

user2044822

135
6

Data too long for column SEX when I insert 1 or 0 too. – flower May 11 '16 at 12:29

How to update the table value field which type is bit using mybatis in mysql?

1 Answers1