I have not found an answer to this either. Anyone?
It doesn’t seem to be possible and it doesn’t seem to make much sense either. Sorting my datasets case sensitive is not working in most scenarios.
See also the other unanswered question.
https://www.wix.com/velo/forum/community-discussion/sorting-a-dataset-via-settings-or-setsort
Perhaps the only way to work around this would be to change your data…
It is possible to add a column to your database that stores the lowercase version of your value, and then sort on that. For example, if you were listing businesses, you would store two values for each record:
- FedEx, fedex
- FDA, fda
- Florida Oranges, florida oranges
Then you can display the first column in your site but sort by the second column.
This is not very elegant though. Wix should support this.