Yes, that's what we're doing. But while ORDER BY would use this
parameter, GROUP BY does not.
Are you saying that it's not possible to use COLLATE with GROUP BY or
that it's not working?
Thanks for the pointers. I'm saying that in the little testing I did
COLLATE did not work with GROUP BY.
I'm no expert in this field but from what I've seen 'here'
(http://www.sqlite.org/lang_select.html) and 'here'
(books.google.de/books?isbn=1449399649) (chapter 9, beginning of
'Collation Functions' on pg 200), I thought it should be possible.
That's interesting. I've googled a bit more, but besides these mention,
there's little to be found about COLLATE and GROUP BY. I think I haven't
found a single line of sample code where it would have been demoed. I'll
run a few more tests and check changelogs. Maybe the version we're
running has an issue...
--
Michael
_______________________________________________
beta mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/beta
