Collation

  • jkacher

    (@jkacher)


    1 year, 1 month ago

    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 with
    DataTables 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.
    • This topic was modified 1 year, 1 month ago by jkacher.
Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Contributor Kim L

    (@kimmyx)

    1 year, 1 month ago

    Hi @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

    Let us know if you have other questions.

    Thread Starter jkacher

    (@jkacher)

    1 year, 1 month ago

    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

    • This reply was modified 1 year, 1 month ago by jkacher.
    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    1 year, 1 month ago

    Hi @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.