On 7 Feb 2019, at 12:12pm, li...@herger.net wrote: > TBH: I didn't even know about this. I thought the COLLATE at the end of the > statement would do it for all.
If you don't want to have to keep specifying the COLLATE, put it in the table definition: CREATE TABLE ... ( ... artist TEXT COLLATE de_DE ...) Then it will be used for every operation involving that column, unless it collides with another specified COLLATE. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
