{"id":18398653,"date":"2025-04-03T23:43:04","date_gmt":"2025-04-03T23:43:04","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/collation-2\/"},"modified":"2025-04-03T23:48:20","modified_gmt":"2025-04-03T23:48:20","slug":"collation-2","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/collation-2\/","title":{"rendered":"Collation"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">I deleted everything on test page, and added the code [wpdataaccess pub_id=&#8221;2&#8243;] to run the query created by Table app.<br \/>The Search responds with<br \/>DataTables warning: table id=item2 &#8211; Illegal mix of collations (utf8mb4_unicode_ci,COERCIBLE) and (utf8mb4_unicode_520_ci,COERCIBLE) for operation &#8216;like&#8217;<\/p>\n","protected":false},"template":"","class_list":["post-18398653","topic","type-topic","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/18398653","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":2,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/18398653\/revisions"}],"predecessor-version":[{"id":18398661,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/18398653\/revisions\/18398661"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=18398653"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}