> Hi there,
> I'm trying to create a list with an index list. Eg. I have artists:
> Šuma Čovjek
> Suzanne Vega
> That's the sort order I'd get using an ICU collation. "Šuma Čovjek"
> would be sorted as "Suma..." as expected.
> Now I'd like to create an index bar by providing groups of the first
> SELECT SUBSTR(name,1,1), count(distinct id) FROM artists GROUP BY
> SUBSTR(name,1,1) ORDER BY name COLLATE de_DE
Aren't you missing a COLLATE clause after the GROUP BY term?