Pasting in content

When pasting in content, please be cautious to make sure that all quotes and apostophes are not "Word" code.

If you're copying in text from MS Word, MS Outlook, and many web sites, they'll often have characters that Microsoft created. Often called curly quotes, these can cause problems with your web site.

You won't notice any problems with your site until you go to update, restore from a backup, etc.

That's when things go weird.

MySQL automatically surrounds each quote or apostrophe is surrounded by a character that tells MySQL that it is in the body of the item, not a break between items. However, it doesn't recognize those curly quotes or apostrphes.

As such, you'll end up with stories that suddenly end in the middle of a word or sentence -- right where that quote or apostrophe should be.

So if you're copying in text, it's best to go through and manually replace each apostrphe and quotation mark so that you're sure they're not Microsoft's curly version.