Title: Plugin Tables Collation
Last modified: November 24, 2022

---

# Plugin Tables Collation

 *  Resolved [kabbill21](https://wordpress.org/support/users/kabbill21/)
 * (@kabbill21)
 * [3 years, 6 months ago](https://wordpress.org/support/topic/plugin-tables-collation/)
 * 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](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [3 years, 6 months ago](https://wordpress.org/support/topic/plugin-tables-collation/#post-16233860)
 * Hi [@kabbill21](https://wordpress.org/support/users/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](https://wordpress.org/support/users/kabbill21/)
 * (@kabbill21)
 * [3 years, 6 months ago](https://wordpress.org/support/topic/plugin-tables-collation/#post-16233951)
 * 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.wordpress.org/Creating_Tables_with_Plugins](https://codex.wordpress.org/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](https://wordpress.org/support/users/kabbill21/).
 *  Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [3 years, 6 months ago](https://wordpress.org/support/topic/plugin-tables-collation/#post-16234454)
 * >>> 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](https://wordpress.org/support/users/kabbill21/)
 * (@kabbill21)
 * [3 years, 6 months ago](https://wordpress.org/support/topic/plugin-tables-collation/#post-16234486)
 * 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](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [3 years, 6 months ago](https://wordpress.org/support/topic/plugin-tables-collation/#post-16234505)
 * Thanks for the additional info Vasilis! I never thought of that… 🙈
 * Thanks,
    Peter
 *  Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [3 years, 5 months ago](https://wordpress.org/support/topic/plugin-tables-collation/#post-16334882)
 * 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.

 * ![](https://ps.w.org/wp-data-access/assets/icon-256x256.png?rev=3299063)
 * [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards](https://wordpress.org/plugins/wp-data-access/)
 * [Support Threads](https://wordpress.org/support/plugin/wp-data-access/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-data-access/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-data-access/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-data-access/reviews/)

 * 6 replies
 * 2 participants
 * Last reply from: [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * Last activity: [3 years, 5 months ago](https://wordpress.org/support/topic/plugin-tables-collation/#post-16334882)
 * Status: resolved