Hi Guys,
I have a requirement where the user has to fill in around 5000 characters in a paragraph field, is it possible to store 5000 characters to the database ?
Discussion posts and replies are publicly visible
What is your current table structure? Are you trying to add a new column or update the existing one?
This is my table structure, and i am trying to update an existing field from varchar(2000) to varchar(5000). Also tried using text field for this requirement, but my process is failing once the user enters more than 4000 characters.
There could be a possibility that total size of all fields in the table is more than the limit, 65535. Try changing all the varchar to text types.
Please refer this thread for more informations
stackoverflow.com/.../row-size-too-large-error-in-mysql-create-table-query
Thanks Soma