Title: Weird database character encoding
Last modified: August 22, 2016

---

# Weird database character encoding

 *  [mauryg](https://wordpress.org/support/users/mauryg/)
 * (@mauryg)
 * [11 years, 3 months ago](https://wordpress.org/support/topic/weird-database-character-encoding/)
 * Using Duplicator v0.5.12 and loving it. I am migrating a number of sites and 
   I noticed that some characters in the posts are not being encoded properly.
    
   For example I get:
 * > ’ in place of ‘
   >  – in place of –  in place of space (beginning or ending)
   > “ in place of opening “ †in place of closing “ So the sentence “If the 
   > park closes,” said Simitian, “that’s 400 low-income folks who are out on the
   > street. comes out as  “If the park closes,” said Simitian, “that’s
   > 400 low-income folks who are out on the street.
 * The installer tells me the encoding is utf8 and the collation is utf8_general_ci.
   This agrees with the MySQL database. What’s going on?
 * [https://wordpress.org/plugins/duplicator/](https://wordpress.org/plugins/duplicator/)

Viewing 9 replies - 1 through 9 (of 9 total)

 *  [Cory Lamle](https://wordpress.org/support/users/corylamleorg/)
 * (@corylamleorg)
 * [11 years, 3 months ago](https://wordpress.org/support/topic/weird-database-character-encoding/#post-5757713)
 * Hey mauryg,
 * Checkout this question on the FAQs page I believe it may help or provide some
   clues about this issue:
    -> Browse to: [http://lifeinthegrid.com/duplicator-faq](http://lifeinthegrid.com/duplicator-faq)-
   > Find question: “How can I fix international characters issues?”
 * Right now its difficult to spot these issues. Sometimes the database.sql file
   that is written to the archive.zip file can actually be written as ASCII, based
   on how PHP is configured. This can mess things up as well, I’m not saying that
   is the issue in your case but it has been for others in the past. I have not 
   found an issue around that exact problem quite yet…
 * Cheers~
 *  Thread Starter [mauryg](https://wordpress.org/support/users/mauryg/)
 * (@mauryg)
 * [11 years, 3 months ago](https://wordpress.org/support/topic/weird-database-character-encoding/#post-5757715)
 * Hi Cory,
    Thanks for the fast reply. Actually when I looked at the FAQs it appeared
   that the item on “How can I fix strange characters” was more relevant. All of
   my articles are in English only. I examined my database with phpmyadmin and the
   encoding is utf8 and the collation is utf8_geneeral_ci. I was tempted to add 
   the correct collation to the wp-config file and see if that made a difference.
   It’s also interesting that while most of the 30 individual MyISAM tables are 
   utf8/utf8_general_ci, 4 of them, associated with particular plugins, are listed
   as latin1_swedish_ci. And the SUM is latin1_swedish_ci. But those plugins are
   not involved with the posts in question. I tried changing the collation parameter
   when I did the install but that didn’t help. The problem was random and did not
   occur in all posts/pages. I wonder if the affected text may have been copied 
   from MS Word or similar source and the internal formatting was the culprit. Worth
   a try. I’ll run a test install and let you know.
 * Maury
 *  [Cory Lamle](https://wordpress.org/support/users/corylamleorg/)
 * (@corylamleorg)
 * [11 years, 3 months ago](https://wordpress.org/support/topic/weird-database-character-encoding/#post-5757757)
 * Hi Mauryg,
 * Sound like your heading in the right direction. Character encoding issues are
   very difficult to pin-point. I have spent hours trying to get things going on
   several system and it can take allot of time troubleshooting, this is why I normally
   just out-source these types of tasks…
 * Hope you make some headway…
 *  Thread Starter [mauryg](https://wordpress.org/support/users/mauryg/)
 * (@mauryg)
 * [11 years, 3 months ago](https://wordpress.org/support/topic/weird-database-character-encoding/#post-5757784)
 * Hi Cory,
    Haven’t had a chance to test all my ideas but just a quick observation.
   I took the one website that gave me the most problems and used WP-Migrate-DB 
   to export a copy of the database only, then imported it into the new site I had
   migrated with Duplicator. Weird characters were gone. So clearly something was
   screwed up in the encoding.
 * Maury
 *  [Cory Lamle](https://wordpress.org/support/users/corylamleorg/)
 * (@corylamleorg)
 * [11 years, 3 months ago](https://wordpress.org/support/topic/weird-database-character-encoding/#post-5757805)
 * Yeah I do plans to try and dig further into this at some point, just need more
   time…
 *  [Primalsource1](https://wordpress.org/support/users/primalsource1/)
 * (@primalsource1)
 * [11 years, 3 months ago](https://wordpress.org/support/topic/weird-database-character-encoding/#post-5757806)
 * Thanks Cory, I’m doing without RSS feeds for now but it would be nice to figure
   this one out. I restored a previous database from before the characters showed
   up but it’s still doing it. Ugh.
 * Ooops I just noticed this wasn’t my post ha ha ha, same issue though or a cousin
   of it anyway….
 *  [Cory Lamle](https://wordpress.org/support/users/corylamleorg/)
 * (@corylamleorg)
 * [11 years, 3 months ago](https://wordpress.org/support/topic/weird-database-character-encoding/#post-5757807)
 * I think the best way for me to help out with these issues is [submit a help ticket](https://lifeinthegrid.com/support).
   This way I can work with your setup and try to pin point what issues are causing
   the encoding issue…
 *  [Primalsource1](https://wordpress.org/support/users/primalsource1/)
 * (@primalsource1)
 * [11 years, 3 months ago](https://wordpress.org/support/topic/weird-database-character-encoding/#post-5757809)
 * How do I put a trouble ticket in? I’ve been looking for a way to do that but 
   have had no luck.
 *  [Cory Lamle](https://wordpress.org/support/users/corylamleorg/)
 * (@corylamleorg)
 * [11 years, 3 months ago](https://wordpress.org/support/topic/weird-database-character-encoding/#post-5757816)
 * Just click on the link above and then click the link “submit a ticket” are you
   unable to see the website?

Viewing 9 replies - 1 through 9 (of 9 total)

The topic ‘Weird database character encoding’ is closed to new replies.

 * ![](https://ps.w.org/duplicator/assets/icon-256x256.png?rev=2906985)
 * [Duplicator - Backups & Migration Plugin - Cloud Backups, Scheduled Backups, & More](https://wordpress.org/plugins/duplicator/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/duplicator/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/duplicator/)
 * [Active Topics](https://wordpress.org/support/plugin/duplicator/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/duplicator/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/duplicator/reviews/)

 * 9 replies
 * 3 participants
 * Last reply from: [Cory Lamle](https://wordpress.org/support/users/corylamleorg/)
 * Last activity: [11 years, 3 months ago](https://wordpress.org/support/topic/weird-database-character-encoding/#post-5757816)
 * Status: not resolved