[eluser]Dan Bowling[/eluser]
I have two distinct problems when a user pastes from word into a simple text area that don't occur when they type in that same text area:
1) If there is special formatting, the SQL update statement fails because of special characters
Quote:Error Number: 1366
Incorrect string value: '\x95 Asds...' for column 'goals' at row 1
2) The update "appears" to succeed (doesn't generate an error) but the content pasted in does not appear, and it updates the field to blank. Even if the pasted text is just a word with no special formatting. Most of the time, this problem can be avoided by typing a space in the textarea before submitting.
Again, these two problems only happen when a user pastes from word.
Any ideas?