Title: Database Collate
Last modified: May 25, 2024

---

# Database Collate

 *  Resolved [Peter Wooster](https://wordpress.org/support/users/pkwooster/)
 * (@pkwooster)
 * [1 year, 10 months ago](https://wordpress.org/support/topic/database-collate/)
 * The database tables created by WP Cookie Consent use a collating sequence that
   is not supported by MariaDB. This causes difficulties moving a site from a MySQL
   to MariaDB server. The unsupported collating sequence is utf8mb4_0900_ai_ci.
 * An example is {prefix}gdpr_cookie_post_cookies

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

 *  [ojas21](https://wordpress.org/support/users/ojas21/)
 * (@ojas21)
 * [1 year, 10 months ago](https://wordpress.org/support/topic/database-collate/#post-17781685)
 * Hi there,
 * Thanks for getting back to us.
 * The issue you are facing is likely due to the the version of MySQL is different
   on live server and local server , please trying updating the version of MySQL.
   
   And if the issue still persist please raise the ticket at [support@wpeka.com](https://wordpress.org/support/topic/database-collate/support@wpeka.com?output_format=md).
 * Thanks for your understanding.
 *  Thread Starter [Peter Wooster](https://wordpress.org/support/users/pkwooster/)
 * (@pkwooster)
 * [1 year, 10 months ago](https://wordpress.org/support/topic/database-collate/#post-17782129)
 * The issue is that the remote server is MySQL, the local server is MariaDB which
   doesn’t support the utf8mb4_0900_ai_ci collate. Something in your plugin is requesting
   that collate as it doesn’t appear in any other database tables.
 *  [ojas21](https://wordpress.org/support/users/ojas21/)
 * (@ojas21)
 * [1 year, 9 months ago](https://wordpress.org/support/topic/database-collate/#post-17829216)
 * Hello, [@pkwooster](https://wordpress.org/support/users/pkwooster/)
 * We apologise for the wait for my response.
 * To receive assistance with this issue, kindly submit a support ticket to [support@wpeka.com](https://wordpress.org/support/topic/database-collate/support@wpeka.com?output_format=md).
   
   We’ll quickly resolve your problem.
 * We appreciate your understanding.
 * Warm regards.

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

The topic ‘Database Collate’ is closed to new replies.

 * ![](https://ps.w.org/gdpr-cookie-consent/assets/icon-256x256.png?rev=3344977)
 * [Cookie Banner for GDPR / CCPA - WPLP Cookie Consent](https://wordpress.org/plugins/gdpr-cookie-consent/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/gdpr-cookie-consent/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/gdpr-cookie-consent/)
 * [Active Topics](https://wordpress.org/support/plugin/gdpr-cookie-consent/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/gdpr-cookie-consent/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/gdpr-cookie-consent/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [ojas21](https://wordpress.org/support/users/ojas21/)
 * Last activity: [1 year, 9 months ago](https://wordpress.org/support/topic/database-collate/#post-17829216)
 * Status: resolved