On Feb 28, 2010, at 11:15 PM, Phil Leigh wrote: > > Does sqllite have locale-based sorting?
Not natively, but DBD::SQLite does (using perl's sort command) and this was implemented several weeks ago. Every SQL command that requires sorting has a "COLLATE perllocale" following the ORDER BY part of the statement. This uses the system UTF-8 locale to do sorting (or whatever other current locale is selected). This may result in differences on some OS's, for example OSX which does not have a correct UTF-8 LC_COLLATE file. I am unsure how this works on Windows. Linux works fine however, which is what we are most concerned with at the moment. _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
