Does exist any way to set the collection collation in the DB?
In my language there are some words which have accent, such as "água" and when I ask to the query to sort the results, the system considers that "água" should appear after "bola".
For instance..
The sorting effect of the set
Bola
Água
Automóvel
Should be: Água, Automóvel, Bola
But the system produces the following result: Automóvel, Bola, Água
Hello Rodrigo,
There is no way to set collection collation in the DB.
But you can set it via JS:
1) Save database service response into storage variable (https://devcenter.appery.io/documenta...)
1.1) Add to the success event JS code of sorting data:
https://developer.mozilla.org/en/docs...
1.2) Save sorted data to the storage variable:
Apperyio.storage.myVariable.set(data); // myVariable - name of storage variable
2) Use this variable in data mapping
Or add additional column for sorting mechanism.