utf8mb4_unicode_ci or utf8mb4_unicode_520_ci

  • Resolved tuomonurkkala

    (@tuomonurkkala)


    1 year, 5 months ago

    Hi there,

    I am looking at my phpMyAdmin and I’m finding few tables of yours in utf8mb4_unicode_ci database character. Should they be in this format instead <dfn title=”Unicode (UCA 5.2.0), case-insensitive”>utf8mb4_unicode_520_ci</dfn> ?

    https://ufile.io/cef61lap

    Best Regards,

    Tuomo Nurkkala

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

Viewing 7 replies - 1 through 7 (of 7 total)
  • Thread Starter tuomonurkkala

    (@tuomonurkkala)

    1 year, 5 months ago

    The previous message came little bit wrong:

    *Should they be in this format instead utf8mb4_unicode_520_ci?

    Plugin Support Maybellyne

    (@maybellyne)

    1 year, 5 months ago

    Hello Tuomo,

    Thanks for your question about WordPress database tables related to the Yoast SEO plugin. Generally, the recommended charset for WordPress sites is utf8mb4 (4-byte UTF-8 Unicode Encoding), and the recommended collation is utf8mb4_unicode_ci.

    Unicode provides a standard that is evolving with the following numbers:

    4.0.0 - utf8mb4_unicode_ci
5.2.0 - utf8mb4_unicode_520_ci
9.0.0 - utf8mb4_0900_ai_ci

    It is generally better to use the latest standard that is available. My advice is to not mess with charsets/collation unless you really know what you’re doing. You stand to corrupt data. if you don’t.

    Thread Starter tuomonurkkala

    (@tuomonurkkala)

    1 year, 5 months ago

    Hi @maybellyne

    Okay, good to know!

    I have alot of your database tables in phpMyAdmin and do I need so many?

    Here are the tables:

    wp_2_yoast_indexable = utf8mb4_unicode_520_ci
    wp_2_yoast_indexable_hierarchy = utf8mb4_unicode_520_ci
    wp_2_yoast_migrations = utf8mb4_unicode_520_ci
    wp_2_yoast_primary_term = utf8mb4_unicode_520_ci
    wp_2_yoast_seo_links = utf8_general_ci
    wp_3_yoast_indexable = utf8mb4_unicode_520_ci
    wp_3_yoast_indexable_hierarchy = utf8mb4_unicode_520_ci
    wp_3_yoast_migrations = utf8mb4_unicode_520_ci
    wp_3_yoast_primary_term = utf8mb4_unicode_520_ci
    wp_3_yoast_seo_links = utf8_general_ci
    wp_4_yoast_indexable = utf8mb4_unicode_520_ci
    wp_4_yoast_indexable_hierarchy = utf8mb4_unicode_520_ci
    wp_4_yoast_migrations = utf8mb4_unicode_520_ci
    wp_4_yoast_primary_term = utf8mb4_unicode_520_ci
    wp_4_yoast_seo_links = utf8_general_ci
    wp_5_yoast_indexable = utf8mb4_unicode_520_ci
    wp_5_yoast_indexable_hierarchy = utf8mb4_unicode_520_ci
    wp_5_yoast_migrations = utf8mb4_unicode_520_ci
    wp_5_yoast_primary_term = utf8mb4_unicode_520_ci
    wp_5_yoast_seo_links = utf8_general_ci
    wp_yoast_indexable = utf8mb4_unicode_ci
    wp_yoast_indexable_hierarchy = utf8mb4_unicode_ci
    wp_yoast_migrations = utf8mb4_unicode_ci
    wp_yoast_primary_term = utf8mb4_unicode_ci
    wp_yoast_seo_links = utf8_general_ci
    Plugin Support Maybellyne

    (@maybellyne)

    1 year, 5 months ago

    The plugin database entries contain wpseo or wp_yoast:

    • wp_yoast_indexable
    • wp_yoast_indexable_hierarchy
    • wp_yoast_migrations
    • wp_yoast_primary_term
    • wp_yoast_prominent_words (note: only available in Yoast SEO Premium)
    • wp_yoast_seo_links
    • wp_yoast_seo_meta

    Are you on a WordPress multisite setup?

    Thread Starter tuomonurkkala

    (@tuomonurkkala)

    1 year, 5 months ago

    Okay and yes I have my wordpress in multisite environment.

    Plugin Support Maybellyne

    (@maybellyne)

    1 year, 5 months ago

    The number included in the database prefix (e.g. wp_4_, wp_3_) indicates a different table for a different WordPress installation. Having a multisite setup means you will have more tables than if it was just a single installation.

    Thread Starter tuomonurkkala

    (@tuomonurkkala)

    1 year, 5 months ago

    Okay, good to know! 🙂

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘utf8mb4_unicode_ci or utf8mb4_unicode_520_ci’ is closed to new replies.