Personal Video Database

English => Support => Topic started by: RedDunce on December 30, 2009, 11:58:43 pm

Title: Lowercase/Uppercase Titles (Sort by Title)
Post by: RedDunce on December 30, 2009, 11:58:43 pm

Why do all lowercase titles appear at the end? For example, eXistenZ and iMurders are at the very bottom of my list, instead of between D and F and H and J, respectively.

Title: Re: Lowercase/Uppercase Titles (Sort by Title)
Post by: nostra on December 31, 2009, 12:25:32 am

It is the way Firebird (the database engine) sorts stuff. I could not find an easy way of changing this behavior.

Title: Re: Lowercase/Uppercase Titles (Sort by Title)
Post by: mgpw4me@yahoo.com on December 31, 2009, 01:01:32 am

Mysql and (most?) other sql databases allow something like:

select title from title_table order by lower(title) asc;

DISCLAIMER: 
Not being familiar with the state of Firebird's standards compliance, I may be totally offbase here.  Wide character sets may also introduce unforeseen issues not resolved by the above.

Title: Re: Lowercase/Uppercase Titles (Sort by Title)
Post by: patch on December 31, 2009, 01:16:50 am

This thread discussed similar options. http://www.videodb.info/forum_en/index.php?topic=1531.0
Knowing how difficult they are to implement is beyond me though.

Title: Re: Lowercase/Uppercase Titles (Sort by Title)
Post by: nostra on January 04, 2010, 01:12:42 am

Quote

select title from title_table order by lower(title) asc;

I am aware of this solution, but there are some different problems to solve that need time...