What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
What is the maximum number of characters that can be stored in a text field?Asked by sjpd 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?
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.
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.
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.
Thanks again. And BTW, Excel limits cell input to 32,767 characters.
Thank you for sharing the excel cell character limits with us.
On your question: I am awaiting a response form our back end team.
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.