Thank you, igor. I've learned one more, today! 2013. 5. 22. 오후 10:20에 "Igor Tandetnik" <i...@tandetnik.org>님이 작성:
> 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 > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users