Title: Collation
Last modified: April 3, 2025

---

# Collation

 *  [jkacher](https://wordpress.org/support/users/jkacher/)
 * (@jkacher)
 * [1 year, 1 month ago](https://wordpress.org/support/topic/collation-2/)
 * I deleted everything on test page, and added the code [wpdataaccess pub_id=”2″]
   to run the query created by Table app.
   The Search responds withDataTables warning:
   table id=item2 – Illegal mix of collations (utf8mb4_unicode_ci,COERCIBLE) and(
   utf8mb4_unicode_520_ci,COERCIBLE) for operation ‘like’
    -  This topic was modified 1 year, 1 month ago by [jkacher](https://wordpress.org/support/users/jkacher/).
    -  This topic was modified 1 year, 1 month ago by [jkacher](https://wordpress.org/support/users/jkacher/).

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

 *  Plugin Contributor [Kim L](https://wordpress.org/support/users/kimmyx/)
 * (@kimmyx)
 * [1 year, 1 month ago](https://wordpress.org/support/topic/collation-2/#post-18398943)
 * Hi [@jkacher](https://wordpress.org/support/users/jkacher/),
 * It looks like you’re using the legacy table builder. Do you have a link where
   we can check this table?
 * We suggest creating data tables using the **App Builder **as the legacy builders
   will be removed in the future.
 * We have a simple tutorial here: [Creating a Data Table App](https://wpdataaccess.com/docs/app-tutorials/create-a-data-table-app/)
 * Let us know if you have other questions.
 *  Thread Starter [jkacher](https://wordpress.org/support/users/jkacher/)
 * (@jkacher)
 * [1 year, 1 month ago](https://wordpress.org/support/topic/collation-2/#post-18400219)
 * One of the columns was data from my function. It uses the cursor to collect data
   from several records.
   Your lookup finds one record, and i need to be able to 
   use a function,select id,book_authors(id) book_authors, title_orig; Your old 
   Table Builder does accept the custom query, the App builder does not[test – OCL](https://onlinecheckerslibrary.com/test/)
    -  This reply was modified 1 year, 1 month ago by [jkacher](https://wordpress.org/support/users/jkacher/).
 *  Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [1 year, 1 month ago](https://wordpress.org/support/topic/collation-2/#post-18401581)
 * Hi [@jkacher](https://wordpress.org/support/users/jkacher/)
 * Custom queries can also be used with the new Table Builder. You only need to 
   make a database view for it. Views are supported like tables. They just do not
   handle transactions.

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

The topic ‘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/)

 * 3 replies
 * 3 participants
 * Last reply from: [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * Last activity: [1 year, 1 month ago](https://wordpress.org/support/topic/collation-2/#post-18401581)
 * Status: not resolved