Re: [sqlite] Using "COLLATE nocase" with BETWEEN

Thank you, igor. I've learned one more, today! 2013. 5. 22. 오후 10:20에 "Igor Tandetnik" 님이 작성: > 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

Re: [sqlite] Using "COLLATE nocase" with BETWEEN

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

Re: [sqlite] Using "COLLATE nocase" with BETWEEN

It works very well if I use "COLLATE" as like as follows. sqlite> select * from mytable where data between 'abc/' COLLATE nocase and 'abc0' COLLATE nocase; abc/ ABC/ abc/a ABC/A abc/b ABC/B abc0 ABC0 sqlite> select * from mytable where data between 'abc0' COLLATE nocase and 'abc/' COLLATE nocase;

[sqlite] Using "COLLATE nocase" with BETWEEN

I've found some unexpected result with "COLLATE" operator. I don't know what if it is a bug or my misunderstanding. Please, check below description. CREATE TABLE mytable (data); INSERT INTO "mytable" VALUES('abc'); INSERT INTO "mytable" VALUES('ABC'); INSERT INTO "mytable" VALUES('abc/'); INSERT