Hi!

It seems that it is not possible to have a custom collation with GROUP BY e.g.
"SELECT * FROM t GROUP BY colA COLLATE NOCASE;"
Is this feature maybe scheduled for an upcoming release of sqlite?
Does anybody have a suggestion for a work around other than creating the column "colA" with COLLATE NOCASE.
"CREATE TABLE t (colA TEXT COLLATE NOCASE);"


Thanks a lot,
Jan-Eric Duden

Reply via email to