Got weird characters showing in your database? Get rid of them.

Database questions, related to MySQL, Microsoft SQL Server, Access and other databases belong in this section.
Post Reply
Posts: 1328
Joined: Fri Nov 08, 2019 12:11 pm
Latest blog post: The magical little can that replaces 4 pantry item...
Answers: 2
Reputation: 615
Location: Central Kentucky USA
Has thanked: 148 times
Been thanked: 40 times

Got weird characters showing in your database? Get rid of them.

Post by Colbyt »

I recently exported a SQL file and restored it on my local drive only to discover a lot of weird characters on my pages. I then restored from the original back-up and still the same result.

I found an article that was written to help you solve the problem with a WordPress database. I had to modify the SQL queries to match my tables but it worked. It is an old article but still relevant advice. A snippet from the site and a link to the article.
During the rush, apparently the most recent database backup file was somehow uncompressed outside of MySQL before final import.

Several days later, that decompression/unzipping basically converted every quotation mark, em dash, en dash, ellipses and other special characters into some really ugly-looking codes.

source: ... -database/
A couple of example of what you might be seeing: “' € ’

I hope this helps you.
Last edited by J. H. Rasmussen on Fri May 29, 2020 5:10 pm, edited 1 time in total.
Reason: Moved to Database forum section.
Reducing my online presence to do some other things.
Post Reply

Return to “Databases”

Who is online

Users browsing this forum: No members and 2 guests