Tag Archive for '“'

Strange text errors after MYSQL database transfer

TEST

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…”