On Aug 22, 2013 8:18 PM, "James K. Lowden" <jklow...@schemamania.org> wrote: > Collation is not a property of the value. Strings are just strings. > They have an *encoding*, necessarily, but not a collation. > > Collation therefore must, by process of elimination, be a property of > the type. And a good thing, too, because it's a property of the > column, and a column is a type.
+1. That SQLite is duck-typed may help confuse this issue, but collation has to be an aspect of a type or an operator, and your arguments are convincing that it is better to associate collation with the type than with the operators (otherwise setting a collation for an binary or trusty operator implies more type casting, which is confusing). Nico -- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
