[igorius]

Maybe there is a big misunderstanding:
Authors is sorting wrong, not Author_sort! Authors is a native column, this one is storing Authors in the manner of "First Name" "Last Name". But sorting is made in the manner of "Last Name" "First Name", which is definitely wrong (Its the sorting of author_sort).

I understand what you all say about author_sort! I have set calibres setting to set the author_sort automatically when an Author is entered when importing a book. I always have a look at this because publishers tend to set these names often the wrong way, say (with single Authors) sometimes the names are right set like Sam Spade, sometimes its set like Spade, Sam or Spade Sam. And when a book has more than one author, things get more funny! Mostly they set names like Sam Spade, & Mike Tool, (note the , after Spade and Tool), so sorting fails -> and i get new authors "Sam Spade," and "Mike Tool,".
But here in my case the name is set right, Authors_sort is right too:

Here you see how Authors should sort the right way!

"Author"......................."Author_sort"
"Aaron Miller"................"Miller, Aaron"
"Ben Cartwright"............"Cartwright, Ben"
"Caesar Burner"............."Burner, Caesar"

This is the way calibre sorts Authors: (Sort from A to Z)

"Author"..........................."Author_sor t"
"Caesar Burner"................."Burner, Caesar"
"Ben Cartwright"................"Cartwright, Ben"
"Aaron Miller"...................."Miller, Aaron"

All times speaking of Authors, a native column! The database stores the names exactly the same way! The Books are stored physically the same way on the harddisk.

So you see the mistake of calibres sorting? Its sorting the same way as in Author_sort.
When i set Author_sort to sort from A to Z, the sorting like this second way is correct!
(I now look at the harddisk to control the authors due to the right sorting)

I hope, the last examples gives the idea, even the pics i uploaded show the same problem!
Sorting of Authors is done by the wrong column Author_sort, not the column Authors!

So in my opinion the sorting of authors is clearly wrong.
If i sort title from A to Z, titles are sorted the right way too:
Adam and the bee
Berta sells flowers
Caesar burns rome
...
Zacharias swims far away

PS: Added 2 pics, one is harddisk, second is the metadata db, sort authors by name ascending.