On Wed, Apr 2, 2014 at 7:45 PM, Richard Hipp <[email protected]> wrote:
> SELECT * FROM table ORDER BY column COLLATE naturalSortOrder; > > Where your special collating function has previously been registered under > the name "naturalSortOrder", then your comparison function will be used to > do the sort, as least for those rows of table where column is type TEXT. > For other datatypes (NULL, INTEGER, REAL, BLOB) the collating function is > ignored. You are sorting just strings, right? > Just out of curiosity: if he changed the ORDER BY to: ''||column, would that then effectively apply the collation to non-string columns? -- ----- stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal "Freedom is sloppy. But since tyranny's the only guaranteed byproduct of those who insist on a perfect world, freedom will have to do." -- Bigby Wolf _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
