Question
Text got truncated after submit
I am using CF 7 and MS SQL 2005.
I have a text field in a form, when I submit the content to database, the text got truncated. There are bout 80000 characters in the text field. In SQL, the column type is ‘ntext’ (I tried both 'ntext' and 'text'. The ‘ntext’ and ‘text’ type in SQL should be able to handle a lot more than 80000, but I don’t know why it got truncated.
When I output the #form.content# on the action page, everything displays fine, so I am wondering if there is any setting in the SQL I can tweak to get this work.
Any help on this will be appreciated.
Thanks,
I have a text field in a form, when I submit the content to database, the text got truncated. There are bout 80000 characters in the text field. In SQL, the column type is ‘ntext’ (I tried both 'ntext' and 'text'. The ‘ntext’ and ‘text’ type in SQL should be able to handle a lot more than 80000, but I don’t know why it got truncated.
When I output the #form.content# on the action page, everything displays fine, so I am wondering if there is any setting in the SQL I can tweak to get this work.
Any help on this will be appreciated.
Thanks,
AdChoices