I've never been able to work out the order either. But, I don't think the ordering is done in SQL. If you manually add books to a collection, then Date Modified sort will work until the device is restarted. I have wondered if the date conversion is broken, but everywhere else it seems to be OK. And when you delete a book from a collection, the order changes. This makes it look like a dictionary is being used and someone is iterating over the contents, not the sorted keys.
|