Some of my database entries come up as a square or a rhombus with a question mark in it. Usually where the apostrophe should be in a html link. This is causing lots of broken links. How can I do a search for these in mysql? -Chris
it is possible that you have chosen a different collation. If you are using php to insert these values make sure you use the escape character \ before the special characters
If someone is pasting from MS word or any MS program with curly quotes and apostrophes it often breaks character sets. This is the most common reason I've seen for exactly what you are experiencing. Long dashes and ellipsis are other common MS character set killers. Otherwise it normally happens when you switch a database's or table's character sets / collation, but don't modify the actual data.