I pasted in some HTML from an email bug report and was surprised to see the message below which I don't recall seeing in the past. I use MS SQL 2014, I would suggest description/comment fields (at least) use nvarchar(max) column properties to not be restricted.

The entered text is too long. It exceeds the allowed limit of 32767 characters.

 
Possible error
We couldn't update the Description value

Workaround:

If possible can include the contents of the multi line text field in a formatted text file and attach to the issue

Additionally, it would be beneficial to implement an exception message that alerts users immediately when the character limit surpasses 32767 characters. This message should be displayed without requiring the user to click the save button, ensuring that any potential issues are visible to them right away.