MySQL VarChar 255 and above

Question

I am currently doing screen scraping and storing in to a MySQL database, I used some of my columns as answer_content varchar(255) NOT NULL,but the problem is some of the data is getting truncated, I was reading following blog post.

But I am not really sure if that is the solution: What is the best solution to save the text without getting them truncated? I am not doing this on a server side and currently doing on a person laptop.

Answer 1

Change the column type to TEXT.

Answer 2

Change type to TEXT

Refer here: http://www.electrictoolbox.com/maximum-length-mysql-text-field-types/