Godaddy 40% Off

40% off your First Order with!

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

Click to support me

Click to support me
If you think my article helps, please click on below advertisement to suppoart me to write more. Thanks