{"id":17780779,"date":"2024-05-25T17:55:23","date_gmt":"2024-05-25T17:55:23","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/database-collate\/"},"modified":"2024-05-25T17:55:23","modified_gmt":"2024-05-25T17:55:23","slug":"database-collate","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/database-collate\/","title":{"rendered":"Database Collate"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">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.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">An example is {prefix}gdpr_cookie_post_cookies<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"template":"","class_list":["post-17780779","topic","type-topic","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/17780779","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/17780779\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=17780779"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}