Page 1 of 1
Natural numeric sort order broken?
Posted: 23 Apr 2007 04:37
by lukescammell
I'm running 2003 server and the natural numeric sort order appears to be broken, eg I'm getting 2.10 before 2.2 and 2.3.
Everything's fine in WE. Don't know if this has happened for a while or only just now - it's late/early.
This happen to anyone else?
Re: Natural numeric sort order broken?
Posted: 23 Apr 2007 08:38
by admin
lukescammell wrote:I'm running 2003 server and the natural numeric sort order appears to be broken, eg I'm getting 2.10 before 2.2 and 2.3.
Everything's fine in WE. Don't know if this has happened for a while or only just now - it's late/early.
This happen to anyone else?
I get this under XP:
2.2.txt
2.3.txt
2.10.txt
2.15.txt
Although I would have found this okay too (reading the first dot as decimal sep):
2.10.txt
2.15.txt
2.2.txt
2.3.txt
Posted: 23 Apr 2007 11:32
by lukescammell
Strange, it's fine at work (XP). Maybe it's just a Server 2003 thing, that would be a real fag :/
I see your point about treating it as a decimal place however, I hadn't thought of that. But isn't that how old Windows treats it anyway?
Posted: 23 Apr 2007 13:39
by admin
lukescammell wrote:I see your point about treating it as a decimal place however, I hadn't thought of that. But isn't that how old Windows treats it anyway?
Yes. With decimal fractions abc- and numeric sorting are identical because all significant positions are written even if they are zero, IOW the leading zeroes are there.