As some others have noticed, there are weird characters showing up on my site (https://edtechfuture.org) – the dreaded Â, Ã¢â‚¬â„¢, Ã¢â‚¬Å“, and Ã¢â‚¬Â, . . . so on and so forth.
From day 1, my WordPress installation has been set to “UTF8” encoding.
I did notice that half of the tables somehow were set to “latin” encoding, instead of “UTF8”. On my development system, I *did* do the database conversion documented here: http://codex.wordpress.org/Converting_Database_Character_Sets – but that seemed to have ZERO effect.
I also installed the “UTF8-Sanitize” plugin. No effect.
I *MANUALLY* edited all the funky characters out of my development site.
Until I exported my database, and re-imported it (as a test). Then, all the funky characters came back. (though the UTF8 settings on all the tables did remain).
And yes, my wp-config.php file says:
The funky characters appear when I browse the tables in myphpadmin, and they appear when I select them in mysql, and they appear in the text-file output in the export – whether I export from myphpadmin, or mysqldump (with the default_character_set set to the default of utf8).
So this “change” appears to happen, every time I export my database. Is this a mysql bug?
One of the things that drives me absolutely batty, is that these characters don’t appear in ALL places. Just SOME.
Also – my RegisterPlus plugin settings, and my TDOMF forms do not survive a mysql export/import. These settings must be manually re-entered. Is mysql export just broken?
And if anyone understands this:
Let me know. I get the “content type” tag, but that’s for an html page, right? My php pages don’t have this. Doesn’t WordPress dynamically generate this html based on the settings?
- The topic ‘mysql database export, and the accursed Â’ is closed to new replies.