troubleshooting database: utf8mb4, utf8

  • werdpres

    (@werdpres)


    4 years, 3 months ago

    i made the mistake of thinking that i added define('DB_CHARSET', 'utf8mb4'); to wp-config long ago, so i commented it out

    most of the site looked fine, but when i loaded the referenced page, all of the post content was gone – it didn’t appear in the editor either

    i’ve since uncommented the define and all seems ok, however this has me wondering why only some pages displayed no post content with the define commented out, yet others did

    i know WP upgraded the db from utf 8 to utf8mb4 long ago, but now i’m wondering if ALL of the db was upgraded and how i can check and repair it if necessary

    The page I need help with: [log in to see the link]

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

    (@a2hostingrj)

    4 years, 3 months ago

    i know WP upgraded the db from utf 8 to utf8mb4 long ago, but now i’m wondering if ALL of the db was upgraded and how i can check and repair it if necessary

    You can read how to perform some basic database check/repairs here.

    Thread Starter werdpres

    (@werdpres)

    4 years, 3 months ago

    thanks for the linking the guide a2

    all db tables check out ‘ok’, which i suspected they would since i don’t think there’s an error with the tables

    the problem, i think, is that some of the post tables are utf8mb4 while others are utf8 and i’m wondering how i can diagnose and fix the problem (i.e. convert whatever utf8 tables that are supposed to be utf8mb4 to utf8mb4)

    a2hostingrj

    (@a2hostingrj)

    4 years, 3 months ago

    You can change the tables collation to individual tables, but before applying that, make a backup of the database.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘troubleshooting database: utf8mb4, utf8’ is closed to new replies.