I want to get content in Grid ordered alphabetically so I used
But as data is coming in French I got wrong order (i.e.: “Finance” then “Électricité”, not “Électricité” then “Finance” as expected).
So in my App I was trying to set collation for database as I did in other apps with PDO function:
But actually I don’t know then how to take advantage of this collation with my model when setting model sorting options with:
Is there any option to set collation for ORDER?
So what I would expect is resulting executed SQL would be:
ORDER BY name COLLATE French ASC
Is it possible with ATK DATA?