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
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
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
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
This topic is locked and no more replies can be posted.
