Re: [sqlite] Can ORDER-BY perform Case-Insensitive comparison?

Bharath Booshan L <[EMAIL PROTECTED]> wrote: > > Consider following query > > SELECT Name > FROM People > ORDER BY Name ASC; > SELECT Name FROM People ORDER BY Name ASC COLLATE nocase; The nocase collating sequence only works for US-ASCII characters. If you need UTF-8 you will need t

[sqlite] Can ORDER-BY perform Case-Insensitive comparison?

Hi All, Eg: People table | EmpID | Name| 21 Rajesh 22 raj 23 Rakesh 24 ramesh Consider following query SELECT Name FROM People ORDER BY Name ASC; will result as Rajesh Rakesh raj ramesh But where as I need the output to be