Re: [sqlite] Stringcompare operator with COLLATE NOCASE

Igor Tandetnik schrieb: > "Lukas Haase" wrote in > message news:gkd3f4$cl...@ger.gmane.org >> This is not what I want. So I use COLLATE NOCASE: >> >> This is the result I want. However, now I need a WHERE clause to work >> exactly the same. So I tried: >> >> SELECT keyword FROM keywords WHERE keyw

Re: [sqlite] Stringcompare operator with COLLATE NOCASE

"Lukas Haase" wrote in message news:gkd3f4$cl...@ger.gmane.org > This is not what I want. So I use COLLATE NOCASE: > > This is the result I want. However, now I need a WHERE clause to work > exactly the same. So I tried: > > SELECT keyword FROM keywords WHERE keyword < 'T*' ORDER BY keyword > COLL

[sqlite] Stringcompare operator with COLLATE NOCASE

Hello, I have a table containting keywords: CREATE TABLE keywords( keywordID INTEGER PRIMARY KEY, keyword VARCHAR(100) ); INSERT INTO keywords VALUES(1,'Apple'); INSERT INTO keywords VALUES(2,'apple'); INSERT INTO keywords VALUES(3,'Angle'); INSERT INTO keywords VALUES(4,'Tree');