English > Support

Lowercase/Uppercase Titles (Sort by Title)

(1/1)

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:

--- Quote ---select title from title_table order by lower(title) asc;
--- End quote ---

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

Navigation

[0] Message Index