Forum Replies Created

Viewing 3 replies - 1 through 3 (of 3 total)
  • keithmcd

    (@keithmcd)

    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

    keithmcd

    (@keithmcd)

    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.

    keithmcd

    (@keithmcd)

    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.

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