Lowercase/Uppercase Titles (Sort by Title)

[RedDunce]

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.

[nostra]

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

[mgpw4me@yahoo.com]

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.

[patch]

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.

[nostra]

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...