Forums

Missing part of text area in database

arvendal 07 Apr, 2013
Hi,

There seems to be a limitation in number of characters when I save my forms to a database table. The content of a text area is limited to 246 chars (with spaces).
Can this be avoided som the whole message will be stored instead of just a part?

Rgds
GreyHead 07 Apr, 2013
Hi arvendal,

The problem will be with the column type in the database table. The ChronoForms Create Table has a default column type of VARCHAR(255) which gives the 'cut off' result you describe. For text areas you should probably set the column to type TEXT. You can change the type easily enough in PHPMyAdmin.

VARCHAR(255) is a fair compromise as a default column type - it's probably too long for most names and phone numbers and too short for some textareas but works most of the time.

Bob
arvendal 07 Apr, 2013
Thanks for your reply.
I'll check this solution.

Rgds
This topic is locked and no more replies can be posted.

VPS & Email Hosting 20% discount

{item:title} {images:#}