On 23 Aug 2013, at 1:14am, Igor Tandetnik <i...@tandetnik.org> wrote:
> Once again, a concrete example:
>
> create table t(x text collate nocase);
> insert into t values ('A');
> select count(*) from t where x = 'a';
>
> In your opinion, what result should this select statement produce? 1, as it
> does now? 0, as Simon's approach seems to imply? Something else?
You seem to thing that I had a problem with this. I don't. If you go back to
my earlier post you will see that I was objecting to the way in which the
COLLATE token was used in expressions. The above does not use COLLATE in an
expression and has nothing to do with my post.
Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
