Plugin Tables Collation

  • Resolved kabbill21

    (@kabbill21)


    3 years, 6 months ago

    Greetings,

    I have a problem with the plugin. The plugin tables (not the ones I create through the plugin) seem to inherit the database collation instead of wordpress collation.
    For example my database collation is latin1_swedish_ci while wordpress table collation is utf8mb4_unicode_520_ci.
    The plugin tables (wp_wpda_project_table, wp_wpda_project_page etc) get latin1_swedish_ci instead of utf8mb4_unicode_520_ci.
    This creates a problem since the site is in Greek, certain things are displayed with question marks.
    Even when I manually change table collation, when I update, the collation reverts.
    Please advise.

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    3 years, 6 months ago

    Hi @kabbill21,

    Thank you for reaching out.

    I checked the create table scripts, there is no collation defined in the scripts. If no collation is defined the default latin1_swedish_ci is used. Which looks correct.

    >>> Even when I manually change table collation, when I update, the collation reverts.

    That’s strange! An update modifies the table content, not the definition.

    Does utf8mb4_unicode_520_ci exist on your server? Did the alter table statement succeed? Please check in the Query Builder:
    show character set

    Shouldn’t utf8mb4_unicode_520_ci be utf8mb3_general_ci?

    Please let us know if this help,
    Peter

    Thread Starter kabbill21

    (@kabbill21)

    3 years, 6 months ago

    Greetings,

    Thank you for you prompt reply.

    You state that latin1_swedish_ci is the collation that the plugin should be installed.

    However WordPress specifications state that creating tables from plugin must inherit wordpress collation.

    https://codex.ww.wp.xz.cn/Creating_Tables_with_Plugins

    Regarding the issue of update, I should clarify I was talking about plugin update. The plugin update reverted the collation.

    • This reply was modified 3 years, 6 months ago by kabbill21.
    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    3 years, 6 months ago

    >>> Regarding the issue of update, I should clarify I was talking about plugin update.
    >>> The plugin update reverted the collation.

    Okay, that info helps! 👍 We’ll look into this and let you know.

    Thanks,
    Peter

    Thread Starter kabbill21

    (@kabbill21)

    3 years, 6 months ago

    Thank you,

    Bear in mind that especially table wp_wpda_publisher holds the column aliases for tables. Therefore, if this table has different collation than WordPress, or even custom user tables created with WP Access, column headers are shown as question marks…

    Thank you in advance for your help,
    Vasilis

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    3 years, 6 months ago

    Thanks for the additional info Vasilis! I never thought of that… 🙈

    Thanks,
    Peter

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    3 years, 5 months ago

    Hi Vasiles,

    Tomorrow we’ll release an update. The update contains a fix for the collation issue. I’ll mark this thread as resolved. Feel free to create a new thread if you have other questions.

    Thank you for reporting this issue,
    Peter

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

The topic ‘Plugin Tables Collation’ is closed to new replies.