External message processing fails if the case comments are larger than 255 characters - External Message

[raulbob]

Bug Description

There is a problem with ExternalMessage and Case caseComments column. A value too long error is caused when processing a DoctorDeclaration with remarks longer than 255.

Reproduction Steps

1. Use a DoctorDeclaration with a large remarks value
2. Messages are not correctly recorded and the processing is inconsistent.
   ...

Expected Behavior

Messages with large remarks should work and be processable while transferring the correct text in the case comments box

Affected Area(s)

Web app

SORMAS Version

1.104.0-SNAPSHOT

Android version/Browser

Any

User Role(s)

Any

Server URL

No response

Additional Information

No response