MySQL Forums
Forum List  »  Newbie

Re: Pasted text not saving
Posted by: Bill Piper
Date: December 12, 2013 03:03AM

Thanks for the reply.
The fact that I can type in more than 255 chars and it works OK seems to suggest that this is not the problem - it is just if I use pasted text.
Apostrophes etc work OK if typed and if pasted in a small chunk.
I'm using mysql_real_escape_string and stripping tags to sanitize the input.
Would formatting characters from MS Word cause a problem? I have tried saving as plaintext from within Word before copy/pasting but that didn't help.
Another thing - I did originally have the field as TEXT but realised this was going to cause problems and altered to LONGTEXT. Is it possible some restrictions are not altered properly by MySQL?

Options: ReplyQuote


Subject
Written By
Posted
December 10, 2013 08:50AM
December 11, 2013 11:04PM
Re: Pasted text not saving
December 12, 2013 03:03AM
December 12, 2013 12:18AM
December 12, 2013 03:08AM
December 12, 2013 06:31AM
December 12, 2013 09:20AM
December 12, 2013 12:56PM
December 13, 2013 10:10AM
December 13, 2013 11:33AM
December 14, 2013 03:02PM
December 13, 2013 01:50PM
December 14, 2013 03:04PM
December 14, 2013 03:06PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.