I have a number of plain text fields in which the users types notes and such. They often like to paste text from Word or PDF and sometimes receive an error similar to this. I have found that the string value is pointing to hidden garbage text. When completely deleted and typed over, the error goes away.
Unusually, I had one instance where one user was able to save the data, then another user, attempting to save the record unchanged, received the save error.
It seems that the text control is able to hold whatever is in there but the database may not be able to save certain non-standard characters. Possibly this relates to various text character standards, unicode, etc.. Out of my league.
Interestingly, no matter what I paste in, I cannot duplicate the issue on any of my machines.
Has anyone encountered this and overcome it?
It seams a plugin could be developed to strip these characters and if that's the answer, my wallet would be open.
