@all of you with 650s:
As I have said, I don't have a 650. However, given the questions in this thread, I read the manual and several reviews. One thing stands out. Apparently a 650 can change the sort order when displaying collections (my 300 cannot). I don't know what all the options are, but it seems that the choices include (at least) author, title, and "by added order".
When calibre builds a collection, it does it in such a way that the reader thinks the books were added in the order dictated by the sort calibre used. As such, calibre's order will (or should) be seen only when 'by added order' is selected. Selecting anything else will sort in some other way. My guess is that choosing author will sort the collection strictly alphabetically using the author field, in which case 'David Weber' will sort before 'Eric Flint' because 'D' is less than 'E'. If there is a title option, then again I guess that it will sort strictly alphabetically, but in this case it might use the title_sort field instead of the title field.
Can anyone confirm the above?
Note that the sony's database, which includes calibre's 'added order', can be seen by looking at the the file at /database/cache/media.xml in the device's memory (not the storage card). There is no problem with looking at this file, but I strongly recommend that you don't change it. It is a text file, and can be opened with notepad++, wordpad, or any other editor that understands unix line endings (\n only). Each book is a line of XML, with the syntax fieldname="some data". The collections are a list of IDs, which refer to the id= attribute in a book's XML. Of interest would be:
- verify that the order of books in a collection in the database matches the order seen when sorting by 'added order'.
- to see if there is a title_sort field for each record, and if so whether it differs from title, and if so whether sorting by title will actually sort by title_sort.
|