Error during Database Character Set Conversion according to Codex

  • Hi,
    I am trying to change the character set of my database from latin1 to utf8, using this officla guideline: https://codex.www.ads-software.com/Converting_Database_Character_Sets

    However, upon executing this

    alter table wp_posts change post_content post_content LONGBLOB;

    no matter in what combination, I get this error message:

    #1283 – Column ‘post_content’ cannot be part of FULLTEXT index

    No matter what I try and how carefully I follow the codex, this keeps happening.

    Please let me know how to fix this.

    An additional question: When I just change the default character set of a table (“ALTER TABLE wp_posts CHARACTER SET utf8;”), this will only affect new posts. I could live with that. Does it truly work that way? Right now my main problem is that I can not use specific html-coded characters (like e.g. non-breaking thinspace). I could live with only being able to use them on future posts. However, I would really like to clean this up thoroughly.

  • The topic ‘Error during Database Character Set Conversion according to Codex’ is closed to new replies.