On 22 Aug 2013, at 1:47pm, Igor Tandetnik <i...@tandetnik.org> wrote:
> You can, actually: hulkify(x) := (case when x = 'the hulk' then 'B' else 'A' > end) . With such a function, "a = b collate muchStronger" is equivalent to > "hulkify(a) = hulkify(b) collate BINARY". In other words, hulkify(x) is to > muchStronger what upper(x) is to NOCASE. The Well Ordering Principle states that you can always devise such a function, given the requirements for SQLite collations. Nevertheless do you understand the point I'm trying to make -- that collations are a modifier for comparisons not individual values ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
