Use standardized title sort and display

[GoogleCodeExporter]

RWhat steps will reproduce the problem?
1. View book list
2.
3.

What is the expected output? What do you see instead?

Dawkins' book 'The Blind Watchmaker' is sorted by its first word, 'The', but 
standard library sort order would sort it by 'Blind', as though the book were 
titled without that word, and appear as 'Blind Watchmaker, The'.

What version of the product are you using? On what operating system?
Latest on Market, Android 2.1

Please provide any additional information below.

Original issue reported on code.google.com by pmccul...@gmail.com on 9 Aug 2010 at 5:34

[GoogleCodeExporter]

I looked into this more and it gets tricky. What about "A is for Alibi"? and 
such, we don't know to remove the leading article then? 

More info 
http://stackoverflow.com/questions/1285849/custom-order-by-to-ignore-the

Original comment by charlie....@gmail.com on 19 Oct 2010 at 3:16

[GoogleCodeExporter]

I think what you are referring to is not "standard," but yes, commonly used. 
Seems like the "mechanical" sort order disregarding leading articles. 

http://en.wikipedia.org/wiki/Library_catalog

"In the mechanical sort order, the first word of the title is the first sort 
term. Most new catalogs use this scheme, but still include a trace of the 
grammatical sort order: they neglect an article (The, A, etc.) at the beginning 
of the title."

We could do this for English, but there are complications for other languages 
as that article notes. 

Original comment by charlie....@gmail.com on 29 Aug 2010 at 6:58

• Changed state: Accepted
• Added labels: Type-Enhancement
• Removed labels: Type-Defect

[GoogleCodeExporter]

Original comment by charlie....@gmail.com on 29 Aug 2010 at 6:58

[GoogleCodeExporter]

At the same time we do the sort by last name, we could add a "title_sort" 
column, and we could strip articles that go in that. Still tough in some cases 
though (like "A is for Alibi"). 

Original comment by charlie....@gmail.com on 19 Oct 2010 at 7:59

• Changed state: Started