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 ...)
Thanks for the hint. But the application is localized to the user's
language. Therefore the collation can have different values.
--
Michael
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
