mherger wrote:
Yeah, I've seen that ORDER BY would treat Å or A the same (depending on
the language settings), but GROUP BY doesn't. Therefore this won't be an
easy fix :-(.
You might be aware of it already, but I wondered how unicode sorting
works in sqlite and found that a collation sequence can be assigned:
http://www.sqlite.org/faq.html#q18
http://www.sqlite.org/datatype3.html#collation
http://stackoverflow.com/questions/611459/how-to-sort-text-in-sqlite3-with-specified-locale
Yes, that's what we're doing. But while ORDER BY would use this
parameter, GROUP BY does not.
--
Michael
_______________________________________________
beta mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/beta
