View Single Post
Old 01-18-2013, 12:24 PM   #1
richardsugg
Junior Member
richardsugg began at the beginning.
 
Posts: 6
Karma: 10
Join Date: Sep 2011
Device: iPad
setting authors.name to authors.sort

I wanted my author names to be the same as the sort field. I didn't see a way in Calibre to do this en masse, so used sqlite3 to do

update authors set name=sort;

The data looked correct, but in the main screen of calibre, all the author names showed up as "Lastname & Firstname" rather than "Lastname, Firstname". If I edit the metadata of an individual book, Calibre correctly shows "Lastname, Firstname" in the author field. It's only on the main screen that the "&" shows up as a separator.

How can I get the author name to be the same as the author sort field?
richardsugg is offline   Reply With Quote