Maximum number of words/characters in Insight Text Field

[Jaber Kakar]

Hi Community,

for a customer I need to know what the limit on text (i.e., text length) is on an Insight text field. The customer is using Insight 9.0.12.

Thanks

[David Sumlin]

From the database perspective, it's basically unlimited. The underlying data type is nvarchar(max) (in SQL Server).

There may (and probably should) be a limit to the text attribute type controlled via the java code. vs textarea attribute type.

If I was to guess, I would think that text maximum would be 255 characters and textarea is unlimited.

[Jaber Kakar]

I tried longer characters while working on a groovy script. I could not figure if there is a limit, and if there is what the limit is. I read in https://community.atlassian.com/t5/Jira-questions/Size-of-attribute-types-Text-and-Textarea/qaq-p/686941 that there is a limit of 450 characters, but it did not apply in my case