Quote:
Originally Posted by BeccaPrice
ok, I'm not sure I know those rules myself, at least not to write them down. Is there a reference somewhere that I can get them?
|
I don't think I could write a clear document on that either
Alpha sort treats everything as Letters (ASCII weight)
'1' is the Letter One and sorts before 'A"
If you want to sort more than a single digit in numeric order, it must be padded (0 is more obvious and reliable than space) to the same number of positions or you get: 1, 10, 2, 20, 200, 3 ... 001, 002, 003, 010, 020, 200 ...
Numbers can have a sign (not sure if Calibre allows negative numbers in the DB)
Dates in Calibre are CE after the year 100 (there was a thread on BC or alternate realities dating )
And the most common issue, people trying to obtain a sort on 2 conflicting fields . Series(_index), Title, or Author
You can't have a book in Series index order And Title order (Unless it is Grafton's: Alphabet Murders
)