- sjpdAsked on May 19, 2015 at 07:17 PM
I have a form where user responses can be quite long narratives.
Is there a limit to the maximum size of a text field where data are stored in the online database?
- JotForm Supportashwin_dAnswered on May 20, 2015 at 12:23 AM
I am not sure if we have a maximum character limit in text box fields. I believe if the maxlength attribute is not defined then maximum length of input value is unlimited. Please check the screenshot below on how to set the maxlength of a text box:
Please be noted that while the textbox can receive unlimited input, the server cannot save the unlimited value.
What is the approximate length you believe will be required for your users? Do let us know and we will make few tests to see if it works fine.
- sjpdAnswered on May 20, 2015 at 10:40 AM
Thank you for your response.
I did already discover your very cool Max Size control. It offers the option to define limts for maximun Words or Characters. I like the way it displays a counter at the bottom of the text area that dynamically counts down as user input is typed.
My question is really about how much data can be stored in the database. There are practical considerations as well as security and usability issues that make setting a maximum limit a good idea.
I've created a form that allows users to compose their narrative in a textarea and it limits input to 10,000 characters. This was the max. limit at Adobe FormsCentral.
My form has a second overflow textarea positioned below the first textarea. It is hidden by default. When the user checks a check-box labeled "Additional Input" at the bottom of the first text area, the second text area is revealed to allow an additional 10,000 characters. This UI device was necessary at FormsCentral due to the max limit, but it also serves to help contrain user input to help them consolidate their narrative.
There is a security consideration that unlimited text areas may invite malicious users to attempt to overrun the input field in an attempt to bloat or break something. So I feel its a best practice to limit input fields as a general rule.
There are network and data integration considerations with an unlimited input field. Excel may have some upper limit for data stored in a cell. (I haven't researched this yet).
I was just looking to determine if your system (user interface or database schema) define any upper limit on text area maximum data length.
I will assume there is some limit on the database, and hope that it is at least 10,000 characters.
- JotForm Supportashwin_dAnswered on May 20, 2015 at 11:02 AM
Well to be able to answer your query, I will have to speak to my back end team.
Let me send a query to them and we will get back to you as soon as we have any update from them.
- sjpdAnswered on May 20, 2015 at 11:04 AM
Thanks again. And BTW, Excel limits cell input to 32,767 characters.
- JotForm Supportashwin_dAnswered on May 20, 2015 at 11:26 AM
Thank you for sharing the excel cell character limits with us.
On your question: I am awaiting a response form our back end team.
- JotForm DeveloperhasanAnswered on May 21, 2015 at 04:26 AM
Our database limit for a single answer is 64kb. That means it can store 65535 single-byte characters.
Please note that some characters like "ß, Ü, €, $" will consume more than 1 byte. However our limitations will be sufficient for your requirements.
If you have any other questions I'll be happy to answer them.
Have a nice day.
- bobAnswered on September 22, 2016 at 09:59 AM