Converting Post Content column to UTF8

  • boborg

    (@boborg)


    4 years, 4 months ago

    When I save a post with special international characters those are turned into a ?

    The WordPress DB is quite old and big. The post_content column in wp_posts is latin1_swedish_ci so I thought I would change it like described in codex here

    So on a backup of the DB I have tried:

    alter table wp_posts change post_content post_content LONGTEXT CHARACTER SET latin1;
alter table wp_posts change post_content post_content LONGBLOB;
alter table wp_posts change post_content post_content LONGTEXT CHARACTER SET utf8;

    The last line gives the error:
    #1366 – Incorrect string value: \xE6ftige… for column mydbname .wp_posts.post_content at row 1

    I have tried searching in PHPMyadmin for Post Content for Like %\xE6% but I do not get any results. In a database dump of the wp_posts tabel I cannot find any \xE6.

    Any ideas?

Viewing 1 replies (of 1 total)
  • Moderator bcworkz

    (@bcworkz)

    4 years, 4 months ago

    In phpMyAdmin, try simply changing the Swedish collation to one of the UTF-8 collations. Note that each text column has a collation, as does each table, and the DB itself. Change them all. It seems collation settings can affect character encoding as well as just collation. All the same, please keep a full backup before making changes.

    You should not attempt to change column data types from what WP had initially setup. Post content column should be LONGTEXT.

    Another forum member recently had a similar issue and simply changing collation fixed it. They did not have to ALTER the charset.

Viewing 1 replies (of 1 total)

The topic ‘Converting Post Content column to UTF8’ is closed to new replies.