Sorting alphabetically is case-sensitive, can it be made case-insensitive?

Questions and Answers Strapi Backend
1
System Information
  • Strapi Version: 4.9.1
  • Operating System: macOS Ventura 13.3.1
  • Database: sqlite
  • Node Version: v18.15.0
  • NPM Version: 9.5.0
  • Yarn Version: 1.22.19

I have a collection type with a text field. I’m able to sort it alphabetically when I make a call to the REST API, but it puts text that starts with a lowercase at the end of the list. Like this:

  • Apple
  • Pear
  • banana

I want the sort to be case-insensitive so it sorts like this:

  • Apple
  • banana
  • Pear

Is that possible?

2

Best option would be to add a extra middleware that resorts in the way you would want