What would be the max no of characters we can save in the database by using para

@ramakg If your question is with respect to usage of SAIL component a!paragraphField(), afaik there isn't any such constraint specified by Appian re the number of characters that can be fed to the component. But if your question is with respect to 'Paragraph Form Component', to the best of my knowledge, there is a limit and it is configurable.

It is also limited by the size of the column in the DB. Take a look at your DB definition for the table. I would recommend limiting the input on the SAIL so that you do not pass a value larger than the DB accepts of the write to DS will fail.

*or the write to DS will fail

would like to store more than 4000 characters in the database by using paragraph field.

Any suggestion?

ok thank you very much for your clarifications

@ramakg There isn't a limit on the size of the characters hold by a!paragraphField(), but it can be a limitation from the DB. So a good way to handle is to put a validation on the corresponding a!paragraphField() as per the length of the field in the database. SAIL recipe at https://forum.appian.com/suite/help/16.1/SAIL_Recipes.html#Approve/Reject_Buttons_with_Conditional_Requiredness is a good example for this.

I think it depends on your database and the respective driver. I remember that when we were using a SQL Server Driver previously we were limited to 4000 characters, however now using the newer driver we can store more than this. Data limits in Appian may be the sticking point.

You can either make use of TEXT or LONGTEXT as a database column data type, if you have a need to store a large amount of data in database column. However, it is always important to add validation at the form field level to restrict the user from typing an value that is greater than the specified database column length value. In this case, a TEXT data type will hold 65535 chars where as LONGTEXT can hold up to 4 Gigabytes of data.

fine in oracle database we can declare the data type as a CLOB to store the huge amount of data but what is the equaling data type in Appian?

when I declare the field as text in Appian it is converting that to varchar2 in database scripts