Roundup Tracker - Issues

Message4984

Author ThomasAH
Recipients ThomasAH, tekberg
Date 2014-01-14.15:34:14
Message-id <1389713654.68.0.23994217108.issue2550829@psf.upfronthosting.co.za>
In-reply-to
I haven't checked if sqlite and/or postgres obey locale settings (or
implement
something similar), but with "sort" it differs very much:

$ echo -e 'a\nA\n*a\n0a\n*A\n0A\nb\nB\n*b\n0b\n*B\n0B'|LC_COLLATE=POSIX sort
*A
*B
*a
*b
0A
0B
0a
0b
A
B
a
b

$ echo -e
'a\nA\n*a\n0a\n*A\n0A\nb\nB\n*b\n0b\n*B\n0B'|LC_COLLATE=en_US.utf-8
sort
0a
0A
0b
0B
a
*a
A
*A
b
*b
B
*B

$ echo -e
'a\nA\n*a\n0a\n*A\n0A\nb\nB\n*b\n0b\n*B\n0B'|LC_COLLATE=de_DE.utf-8
sort
0a
0A
0b
0B
a
A
*a
*A
b
B
*b
*B

Maybe just prepend "000_" or something like that?
History
Date User Action Args
2014-01-14 15:34:14ThomasAHsetmessageid: <1389713654.68.0.23994217108.issue2550829@psf.upfronthosting.co.za>
2014-01-14 15:34:14ThomasAHsetrecipients: + ThomasAH, tekberg
2014-01-14 15:34:14ThomasAHlinkissue2550829 messages
2014-01-14 15:34:14ThomasAHcreate