Forums

Hi all🙂

I just created a form with a textarea field and found that text submitted by users was being cut off at the 255-character mark.

I quick check of the database showed that the textarea field was created as a VARCHAR field in the database with, of course, a 255 character limit. I changed the field to a TEXT field and gave it a much higher character limit.

I'm not sure if this is the standard behaviour of Chronoforms to setup textarea fields with such a limited size or not, or if I did something wrong, but I thought I should mention it because it does seem rather too small for a textarea field.

Hi grumpster,

ChronoForms sets the fields to whatever you specify in Create Table. The default is VarChar 255 for every field but you can change that to Text or to TinyInt if VarChar 255 isn't appropropriate.

Bob

D'oh!

You are correct, sir!

I guess I just got hyp-mo-tized by those crazy red and green colors on the table. I tend to go in, check the x's (or is it x the checks?) and get out of there as quickly as possible.😉

Thanks again, Greyhead ... you make Chronoform'ing a real pleasure🙂

Hi Grumpster,

;-)

I know that feeling. There is a practical limitation that Max has only allowed VARCHAR(255) whereas MySQL will allow VARCHAR(1), or VARCHAR(9999), or . . . You can change these in PHPMyAdmin to tune the table if needed but, for most purposes, VARCHAR(255) is a reasonable compromise.

Bob