We're trying to insert values into an existing database table and one of the columns in a bit(1).
When we execute the insert we get the following error:
Insert Data ERROR [HY000] [MySQL][ODBC 5.3(w) Driver][mysqld-5.6.19-67.0-log]Data too long for column 'is_template' at row 1
Any ideas on how to insert a bit into a table? the value we're trying to insert is '0', so it's not an actual problem with the value not being representable by a bit(1).