On 12/29/05, MythTV <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] | 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 _______________________________________________ mythtv-dev mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
