Are you talking about the same thing as this thread
Sorting Authors by Name is wrong in 6.4?
TLDR: Calibre use a differente value that the displayed "Authors" for sort them column. Ditto with the title.
You could change this behavior with some manipulation for the author, but not sure for the title.