[mythtv] Re: [mythtv-commits] Ticket #896: TV Shows that start with a lowercase letter get sorted after shows that are capitalized in browse recordings with mythtv-0.18.1

[Robert Johnston]

On 12/29/05, MythTV <mythtv at cvs.mythtv.org> wrote:
> #896: TV Shows that start with a lowercase letter get sorted after shows that are
> capitalized in browse recordings with mythtv-0.18.1
> -------------------------------------+--------------------------------------
>  Reporter:  Ross.Campbell at gmail.com  |       Owner:  ijr
>      Type:  enhancement              |      Status:  new
>  Priority:  minor                    |   Milestone:  0.19
> Component:  mythtv                   |     Version:  0.18.1
>  Severity:  low                      |
> -------------------------------------+--------------------------------------
>  I recently noticed when recording "seaQuest DSV" that the recordings were
>  sorted at the end of my recordings - presumably because the show's name
>  starts with a lowercase s.
>
>  This may be somewhat obscure, but there's certainly no rule that says a TV
>  show name must start with a capital letter. I believe shows should be
>  ascii sorted, but for the alpha range, I'd want it to be case insensitive.

Yay! ASCII-Betical sorting rears it's ugly head.

I believe this sorting is done in the SQL, in which case a simple
"ORDER BY LOWER(title)" (Or the equivalent) would solve this problem.

If it's being done in the backend, however, it could mean "Optimising"
the sort routine to sort lower-cased, but preserve case for display.
--
Robert "Anaerin" Johnston