[datatables] ignores collation setting for numerical sorting
krabina opened this issue · 0 comments
krabina commented
Setup
| Product | Version |
|---|---|
| MediaWiki | 1.35.8 |
| PHP | 7.4.3 (fpm-fcgi) |
| MariaDB | 10.3.34-MariaDB-0ubuntu0.20.04.1 |
| ICU | 66.1 |
| Elasticsearch | 6.8.23 |
| Semantic MediaWiki | 4.0.2 |
| Semantic Result Formats | 4.0.1 (dc64c23) 14:27, 11 November 2022 |
Issue
When you change the entity collation in MediaWiki and SMW to "numeric", the categories sort pages named
1 - Lorem ipsum...
2 - Lorem ipsum...
11 - Lorem ipsum...
correctly. With the default, they would sort
1 - Lorem ipsum...
11 - Lorem ipsum...
2 - Lorem ipsum...
However, the datatables format is not agnostic of this. While regular result formats like list, table etc. now sort correctly (after you have run the update scripts), the datatables format is still not showing the correct natural numbering order.
There are several other sorting issues with datatables, e. g. #571, #211, #107 and #2427