Using pipe in a system call

Chris Angelico rosuav at gmail.com
Fri Oct 9 03:21:25 EDT 2015


On Fri, Oct 9, 2015 at 5:56 PM, Cecil Westerhof <Cecil at decebal.nl> wrote:
> My bad, I intended to mention that ORDER BY gives the wrong order (é
> comes after z and with sort it comes after e), so that is why I use
> the external sort command.

Can you configure SQLite's locale? That ought to resolve that. Failing
that, I'd be inclined to take the data into Python as Unicode strings,
and do a locale-based sort of those strings (or tuples of strings).

ChrisA



More information about the Python-list mailing list