"Lukas Haase" <lukasha...@gmx.at> 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
> COLLATE NOCASE ASC;
SELECT keyword FROM keywords
WHERE keyword < 'T*' COLLATE NOCASE
ORDER BY keyword COLLATE NOCASE ASC;
Or, you could just specify the collation in the CREATE TABLE statement,
then it would be used by default both for comparisons and for sorting:
CREATE TABLE keywords(
keywordID INTEGER PRIMARY KEY,
keyword VARCHAR(100) COLLATE NOCASE
);
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
