Evaluate the increase the size of the act_details value column from 5000 to 10000 characters.
This has been implemented by some practices to increase the size of clinical notes.
There is an upper row size limit of 21845 characters; beyond this, a TEXT or BLOB column must be used which is not practical. The maximum length of the value column is 21330 characters (i.e. UTF-8)