Tribler separates capital and not capital letters while sorting by name

[kotenok2000]

Describe the bug
Tribler separates
To Reproduce
Steps to reproduce the behavior:

1. Go to discovered channels
2. Click on Name to sort by name
3. Scroll down
4. See that tribler separates channels with name beginning with capital letter from channels with not capital letter.

Expected behavior
Tribler treats capital and not capital letter the same.
Screenshots
If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information):

• OS: Windows 11
• Tribler's version 7.11.0

Additional context
Add any other context about the problem here.

[devos50]

Great find, thanks for reporting! We will have a look at it 👍

[devos50]

This seems to be possible by using a QSortFilterProxyModel, and by adding proxy_model.setSortCaseSensitivity(Qt.CaseInsensitive). The problem, however, is that we need to set this proxy model as the main model in TriblerTableViewController. The proxy model, however, does not have the attributes that the original model exposed (e.g., data_items) and we have to replace calls to self.model() with self.model().sourceModel(). This can be error prone since not all table logic is covered by the GUI tests.

[ichorid]

The sorting is done by Channels endpoint only. So, it should be fixed in SQL queries on the Core side.

[devos50]

Ah, I missed the server-side sorting part, thanks 👍

[kotenok2000]

Can you look at this issue too?
#6712