Search This Blog

Tuesday, April 12, 2011

Data too long for column 'xxxxx' at row 1

Try to update a column showContent which is boolean datatype in tbl_page table in mysql

UPDATE tbl_page SET showContent='1' WHERE pk=13

and hit error message "Data too long for column 'showContent' at row 1"

After try around and figure out below solve my issue

UPDATE tbl_page SET showContent=1 WHERE pk=13