CREATE TABLE ABCD
(
ID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT ,
Name VARCHAR
(
50
)
NULL
)
Table ABCD has following data:-
ID Name
1 Test
2 test
3 aaa
My query "select Name from ABCD order by Name" The expected result
aaa
Test
test
but I am getting
Test
aaa
test
Do I need to use COLLATE NOCASE while performing sorting on name column?
Why?
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
