On 5/22/2013 12:53 AM, Yongil Jang wrote:
But, in case of using BETWEEN operator with "COLLATE nocase", it returns
unexpected result as follows.
sqlite> select * from mytable where data between 'abc/' and 'ABC0' COLLATE
nocase;
Make it
where data COLLATE nocase between 'abc/' and 'ABC0'
The expression "x between a and b" behaves the same as "x >= a AND x <=
b". In your example, you end up with
data >= 'abc/' and data <= 'ABC0' COLLATE nocase;
The two comparisons use different collations.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
