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 ------------------------------------------------------------------------ reinholdk's Profile: http://forums.slimdevices.com/member.php?userid=36070 View this thread: http://forums.slimdevices.com/showthread.php?t=101264
_______________________________________________ beta mailing list beta@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/beta