Title: MySQL collation type
Last modified: August 31, 2016

---

# MySQL collation type

 *  Resolved [sillinguist](https://wordpress.org/support/users/sillinguist/)
 * (@sillinguist)
 * [10 years, 2 months ago](https://wordpress.org/support/topic/mysql-collation-type/)
 * Greetings,
    I was recently looking at my database and noticed that your plugin
   does not produce tables with the same collation character set as the current 
   version of wordpress.
 * I was particularly looking at the table `wp_sdm_downloads`. It is in a charset
   labled `utf8_unicode_ci`. My understanding is that the current version of wordpress
   uses `utf8mb4_unicode_ci`. I was recently reading the core announcement here:
   [https://make.wordpress.org/core/2015/04/02/the-utf8mb4-upgrade/](https://make.wordpress.org/core/2015/04/02/the-utf8mb4-upgrade/)
   and watching [https://www.youtube.com/watch?v=yQaRUEwEKxE](https://www.youtube.com/watch?v=yQaRUEwEKxE).
 * So here is my question: _because your table is not using the same collation as
   WP Core, does that mean that by using your plugin it it opens up a website to
   security vulnerabilities, of the same type as WP Core had before it was able 
   to handle 4 byte unicode characters?_
 * [https://wordpress.org/plugins/simple-download-monitor/](https://wordpress.org/plugins/simple-download-monitor/)

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

 *  Plugin Contributor [mbrsolution](https://wordpress.org/support/users/mbrsolution/)
 * (@mbrsolution)
 * [10 years, 2 months ago](https://wordpress.org/support/topic/mysql-collation-type/#post-7105460)
 * Hi Hugh, thank you for reporting this with us. The plugin developers will investigate
   further your suggestion.
 * Regards
 *  Plugin Author [mra13](https://wordpress.org/support/users/mra13/)
 * (@mra13)
 * [10 years, 2 months ago](https://wordpress.org/support/topic/mysql-collation-type/#post-7105502)
 * Hi, This has nothing to do with any security vulnerability.
 * A database collation is a set of rules for comparing characters in a character
   set. Your data is just as safe.

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

The topic ‘MySQL collation type’ is closed to new replies.

 * ![](https://ps.w.org/simple-download-monitor/assets/icon-128x128.png?rev=973803)
 * [Simple Download Monitor](https://wordpress.org/plugins/simple-download-monitor/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/simple-download-monitor/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/simple-download-monitor/)
 * [Active Topics](https://wordpress.org/support/plugin/simple-download-monitor/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/simple-download-monitor/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/simple-download-monitor/reviews/)

## Tags

 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)
 * [unicode](https://wordpress.org/support/topic-tag/unicode/)
 * [utf8](https://wordpress.org/support/topic-tag/utf8/)
 * [utf8mb4](https://wordpress.org/support/topic-tag/utf8mb4/)

 * 2 replies
 * 3 participants
 * Last reply from: [mra13](https://wordpress.org/support/users/mra13/)
 * Last activity: [10 years, 2 months ago](https://wordpress.org/support/topic/mysql-collation-type/#post-7105502)
 * Status: resolved