I need to write an SQL query for MySQL to go through my database and replace symbols. I have a form people can copy and paste from Microsoft Word from. It brings all sorts of bizarre encoding problems with it.
I am seeing the following in place of an apostrophe: â€•
My SQL query can find and replace the "â€" portion just fine. When I ask it to find that round bullet point, however, it can't. Despite the fact that I copied and pasted the bullet point directly from an SQL entry, it can't find it. Is there any way to include it in a query to get MySQL to find it?