andyg;521621 Wrote: > 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. fwiw, here's my system locale (on Ubuntu 8.10):
LANG=en_US.UTF-8 LC_CTYPE="en_US.UTF-8" LC_NUMERIC="en_US.UTF-8" LC_TIME="en_US.UTF-8" LC_COLLATE="en_US.UTF-8" LC_MONETARY="en_US.UTF-8" LC_MESSAGES="en_US.UTF-8" LC_PAPER="en_US.UTF-8" LC_NAME="en_US.UTF-8" LC_ADDRESS="en_US.UTF-8" LC_TELEPHONE="en_US.UTF-8" LC_MEASUREMENT="en_US.UTF-8" LC_IDENTIFICATION="en_US.UTF-8" LC_ALL= -- aubuti ------------------------------------------------------------------------ aubuti's Profile: http://forums.slimdevices.com/member.php?userid=2074 View this thread: http://forums.slimdevices.com/showthread.php?t=75730 _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
