Quote:
Originally Posted by BeccaPrice
Where do special characters come in? for example, I've got "-And he built a crooked house" that sorts first, because of the -.
it's not classic ASCII sorting, because lower case and upper case letters are treated the same.
also, my dates are European style (dd/mm/yyyy) - is there a tweak to put them American style (mm/dd/yyyy)?
|
Classic ASCII sorting is punctuation (some of the characters over the Number keys))0-9A-Z(the punctuation on the main keyboard) then a-z (shifted punctuation on the main keyboard) : ASCII32 (space) to ASCII126 (tilde)
There are International ASCII sorts that map Upper and Lower together)
Calibre Date-Time is numeric underneath so display format does not matter (This is NOT for a Text field that has numbers and slashes. ASCII dates should always be entered YYYY/MM/DD Month a day must have leading 0's below 10. the seerator does not matter as long as it is consistent over all records)