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
Hi Jishnu Magunta
In Database VARCHAR columns can store up to 8000 characters
Yes but when i try to change the varchar length, i am getting the below error.
Query error:#1118 - Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
The error message says: "You have to change some columns to TEXT or BLOBs". The field type TEXT is a good start.