Tablepress Turkish characters problem

  • Resolved iyurtsever

    (@iyurtsever)


    4 years, 10 months ago

    Hello,

    I have tablepress plugin and Table Row Order extension installed.
    My wp_posts table collation is utf8mb4_turkish_ci

    Unfortunately when I order rows ASC, or DESC with tablepress, all turkish characters starting with ?,?,?,? etc comes at the end and not at correct order.
    How can I fix this characters issue?

    Best

    • This topic was modified 4 years, 10 months ago by iyurtsever.

    The page I need help with: [log in to see the link]

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    I see what you mean, but unfortunately, don’t know a solution to this. The sorting is done by PHP here, which apparently sorts this by “alphabet”, where the normal characters come first and only then come these special characters.

    Regards,
    Tobias

    Thread Starter iyurtsever

    (@iyurtsever)

    Hi Tobias,

    Thanks for quick reply.

    Sorting is done by PHP or MySQL ORDER BY?

    Because I found really interesting behaviour here. When I look from the wordpress dashboard -> TablePress->All Tables -> Preview it seems that it is sorting correctly including special characters.
    But When I put this table to a page then it is putting this special characters to the end. So I think this is something we can fix. How can I can send you screenshot ?

    • This reply was modified 4 years, 10 months ago by iyurtsever.
    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    the sorting is done in PHP (if you are using the Table Row Order Extension).

    For screenshots, please upload them to e.g. https://imgur.com/ and post a link here.

    Regards,
    Tobias

    Thread Starter iyurtsever

    (@iyurtsever)

    Yes I am using Table Row Extension.

    Here I put my screen shots. In screen shots you can see Turkish Letters are also coming in correct order in TablePress Preview section. But when we put this in page it starts to put Turkish Letters to the end.

    https://kibristurkbarolarbirligi.org/public/tablepress-1.png
    https://kibristurkbarolarbirligi.org/public/tablepress-2.png
    https://kibristurkbarolarbirligi.org/public/tablepress-3.png

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    well, if everything is okay there, I can only suggest to not use the Table Row Order Extension. The order in the Preview is your manual order from adding the data.

    Regards,
    Tobias

    Thread Starter iyurtsever

    (@iyurtsever)

    Ok, but how can we add new rows later in correct order? I think there is no way to do it.
    We can not slide all rows one by one ??

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    to add new data, you could either insert them in the correct place (click the checkbox on the left of a row and then use the “Insert” button), or you move it up/down with drag & drop (by clicking and holding the row number on the left).

    Regards,
    Tobias

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Tablepress Turkish characters problem’ is closed to new replies.