Posted 1 year ago #
If I activate multisite in my wp-config.php using the line
define( 'MULTISITE', true );
Then my site starts displaying  characters where ever a space is usually located. As soon as I remark out the define multisite line the problem goes away. Can anyone shed some light on what is happening and how I might go about fixing this.
Thanks
First I've heard of that particular issue.
One thing to check is with your webhost and to make sure (if you're on shared) they will support you turning this on.
Posted 1 year ago #
I'm having this exact same issue however I have not tried to disable multisite as I noticed after having setup three other blogs. The other blogs are all converts from normal wordpress blogs and have no issues such as this.
What's your database character set?
Posted 1 year ago #
I had researched more after my post - this is related to my site existing in the pre-2.1.3 days when latin1_swedish_ci was the default on the db. new sites are shown as utf8_general_ci.
I've ready up and have seen that I can perform a lot of sql (which I've got no issue doing) to convert the latin1 tables to utf8 or just take a dump, edit the dump, drop tables, then re-import to fix. Seems like that would be easier/quicker but are there any downsides?
It looks like the root issue is because I use double-spaces after periods and there's encoding issues there (only saw maybe one article that had mentioned that). The database itself does not "show" the A.
Posted 1 year ago #
All fixed.
Best way to fix: take a dump of all the tables which were in latin1_swedish_ci collation, edit the sql to use utf8 instead of latin1, reimport it while letting it drop the previous table.
After that, the  will show up in the database table contents. So, run the following sql to fix. I only fixed the wp_posts table (specifically post_content) but there may be others that are affected.
UPDATE wp_posts SET post_content = REPLACE(post_content, 'Â', '');
All fixed and pretty pretty. :-)
Keith
This topic has been closed to new replies.
