Hi Michael,

Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

-

I am unable to reproduce the sorting as you described it.

It has been like this before and is still the same, when it comes to sorting in our SQL Tables, it will depend on your DB Collation in the source DB Table.

For example, if i have this Manual Table, and just add a couple of new rows/ and edit one existing row from the middle of the Table, with special characters, like ` or ~  , and if i set to sort the Table on this String Column, then it does push these symbols at the end for "ascending" Sorting, as expected.

Can you please check what is your SQL Database Table Collation for the Table, and for the String Column you are sorting on, that is probably the root of the issue?

Different Collations can have different sorting rule in the SQL.

On my Table, the current Collation is : utf8mb3_general_ci.

Let me know if that helps to isolate the sorting issue.

Thank you.

Hi Michael,

I am doing pretty good, thank you.

I hope you are doing all right, as well.

-

I checked with our 2nd level Team, and we made a conclusion why this sorting issue happens.

This is a limitation coming from the PHP& SQL Parser we use for our SQL Query Feature.

It is not recommended to use "ORDER BY" in the Query for your Table - because in that case, you will not be able to properly use any sorting from our Plugin on this table.

-

So, if you need to place "ORDER BY" as part of the Table Query, then disable the Sorting on this Table, and it will work fine.

You just won't be able to allow users on front-end to click in the Column headers to change sorting - it will just always sort as you set it in your Query.

If you combine "ORDER BY" in the Query, and still enable our Table's Sorting in the Plugin, it will not work correctly, and it will mess it up.

2. Or, if you remove "ORDER BY" from the Query,  then you can just go in our Table's Column settings and simply set that Column to sort the table by ascending order, and it will work.

Also, it is recommended to avoid having the accent grave (`) symbol around Column names, or Table names in our SQL Parser, to avoid any filtering/sorting/search issues.

( Unless if you disable server-side processing/for tables less than 2 thousand rows).

Let me know if that helps and if you have any questions.

Hello Michael.

Milos is out sick, so I'll jump in.

The database dump you sent us did show some errors when I tried to import it into my database:

But it seems the VIEW generation from your query still works. In the generated table, however, I don't see "~" and as these tables that were included in the dump had some errors, they are missing unique columns (and I can't add them), so I can't edit any data in there to manually enter "~".

Can you send me a new dump that contains this character?

Also, this might help - the collation on our end is utf8mb4_unicode_ci