I recently moved a database from one mysql server to another and ended up with some weird text. It seems that some characters were changed into some crazy text. Here’s what I found and here’s what I think they were originally. I did a massive find and replace using phpmyadmin to fix them.
One error appeared as this
’
I think the original one was a single quotation so I replaced it with this
‘
One error appeared as this
—
I think the original one was a dash so I replaced it with this
-
One error appeared as this
“
I think the original one was a double quotation so I replaced it with this
”
One error appeared as this
â€
I think the original one was a double quotation so I replaced it with this
”
It’s kind of crazy but now the text seems normal on the site. It looks like it could be some messed up language.
Guy #1 ” Soooooo…. ’ — “ â€?”
Guy #2 “HAHAH! ’ — “ â€â€™ — “ — “ †’ — “ â€!? You crazy…”
Hi Smoother,
I know this is a very old article but i am experiencing the same problem for 4 days and it’s driving me crazy, ’cause i can’t find the reason to that. Can i ask you how you managed to solv it ?
I went into phpMyAdmin, then I clicked on the database I’m having the issue with, then I clicked on SQL to run a query. The query looks something like this
UPDATE tablename SET tablefield = replace(tablefield, “findstring”, “replacestring”);
For wordpress it looks something like this
UPDATE wp_posts SET post_content = REPLACE (
post_content,
‘Item to replace here’,
‘Replacement text here’);
Some links to help you out
Search and Replace in WordPress MySQL Database
How to Search and Replace WordPress In Blog Post
phpMyAdmin search and replace
Find and Replace in MySQL using phpMyAdmin