One of the column in my table was initially created as a varchar(1000). Now there is a need to increase the size of that column to hold around 5000 characters. I used the
alter statement to increase the size of that column.
DESC table_name as well as
SHOW CREATE TABLE table_name clearly indicates the new size of that column to be 5000 characters. However, interestingly when I try to insert any data exceeding 1000 characters
ERROR 1406 (22001) : Data too long for column error shows up.
Out of desperation I changed the datatype to text, and still it's limited to 1000 characters. Any suggestion?
I created an other dummy table with a column size of varchar(5000) and that works just fine.
Engine used is InnoDB and Default Charset is UTF8.