Hi colleagues. I faced the issue of the Sort feature - it is case sensitive (e.g. for Ascending sort - first goes Upper case Names, only then lower case).
My tech stack: Fiori Elements and CAP with Node.js with ODatav4.

A table inside List Report presents entities properties and with enabled Draft mode. And the problem is that on deployed systems the sort feature is case sensitive (first go Upper case Names, only then Lower case).
But in the local environment sorting works nice, as requested (the screenshots are below).
For local setup we are using SQLite vs Hana in deployment envs.
Maybe somebody knows what is wrong and how to fix it.
Thanks.
Correct sorting, ASC (like we want - names with small capital letters are among names with uppercased names):

Wrong sorting, ASC (actual behavior - names with small capital letters are below the names with uppercased names):
