On Thu, 6 Nov 2014 17:02:26 -0500
Richard Hipp <d...@sqlite.org> wrote:
> > sqlite> INSERT INTO test VALUES ('b'), ('A'), ('B'), ('a');
> > sqlite> SELECT * FROM test;
> > b
> > A
> > B
> > a
...
> > sqlite> SELECT * FROM test WHERE LTRIM(col)<'b';
> > A
> > B
> > A
...
> Works as designed. See
> https://www.sqlite.org/datatype3.html#collation and in particular the
> three rules under section 6.1.
Aren't you overlooking the fact that the WHERE clause is changing not
only which rows are selected, but the *values* of those rows?
I don't understand how any WHERE clause can convert 'a' to 'A' in the
database. I'm unable to find any suggestion of such in the collation
documentation.
--jkl
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
