Kishor: Collation is okay for case insensitivity but since here we have digits and special chars I think it may not be helpful. Plz correct me if I am wrong.
Puneet Kishor-2 wrote: > > > > Harish CS wrote: >> Hi, >> We have a problem with a sql query. >> In a table, a column called "name" contains character data that may >> include >> alpha, numeric and special characters. It is required to sort in such a >> way >> that names starting with alpha characters are listed first, then numerals >> and finally special characters. > > > Read up on collation on sqlite.org > > > >> For example, the column contains data: [Bhaskar, 5th user, anand, ##, >> Anand, >> bhaskar ]. >> When lsited, it should appear as [Anand, anand, Bhaskar, bhaskar, 5th >> user, >> ##]. >> The query "select name from mytable order by name asc;" lists data in >> this >> order [##, 5th user, Anand, Bhaskar, anand, bhaskar], which is not >> correct. >> Any ideas on this? All thoughts are welcome. >> -Thanks >> Harish > > > > -- > Puneet Kishor http://punkish.org > Carbon Model http://carbonmodel.org > Charter Member, Open Source Geospatial Foundation http://www.osgeo.org > Science Fellow > http://creativecommons.org/about/people/fellows#puneetkishor > Nelson Institute, UW-Madison http://www.nelson.wisc.edu > --------------------------------------------------------------------------- > Assertions are politics; backing up assertions with evidence is science > =========================================================================== > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://old.nabble.com/SQL-query-on-sort-order-tp30455015p30462063.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
