Re: [sqlite] sort by in Sqlite

Kalyani Phadke wrote: > but I am getting > Test > aaa > test > > Do I need to use COLLATE NOCASE while performing sorting on name column? Yes, because the default COLLATE is memory based (just compares bytes). You get what you expect either by using "ORDER BY lower(Name)" (or upper, off cours

Re: [sqlite] sort by in Sqlite

On 5 Aug 2009, at 8:43pm, Kalyani Phadke wrote: > My query "select Name from ABCD order by Name" The expected result > aaa > Test > test > > but I am getting > Test > aaa > test How are you getting these results from ? Are you typing your SELECT command into the command-line tool or using ano

[sqlite] sort by in Sqlite

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