[ENG-1831] Properly sort item names

[iLynxcat]

As of now, we are simply sorting files via SQLite sort. In order to reliably produce results that worldwide users expect, we should properly account for other non-English-like character sets when sorting files.

[iLynxcat]

Renamed issue to specify that this should properly account for number sorting as well.

small problem but when i sort by name it skips numbers. so like here it goes from 1, 10, 101, 102, etc until 109, then it goes down to 11, before it lists 110, 111, 112, and so on.

Posted in Discord by 0mw July 29, 2024

cc @matheus-consoli

[linear]

ENG-1831 Properly sort files in non-Roman alphabets