Author Topic: Lowercase/Uppercase Titles (Sort by Title)  (Read 5077 times)

0 Members and 1 Guest are viewing this topic.

Offline RedDunce

  • Member
  • *
  • Posts: 23
    • View Profile
Lowercase/Uppercase Titles (Sort by Title)
« 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.

Offline nostra

  • Administrator
  • *****
  • Posts: 2852
    • View Profile
    • Personal Video Database
Re: Lowercase/Uppercase Titles (Sort by Title)
« Reply #1 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.
Gentlemen, you can’t fight in here! This is the War Room!

mgpw4me@yahoo.com

  • Guest
Re: Lowercase/Uppercase Titles (Sort by Title)
« Reply #2 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.

Offline patch

  • Older Power User
  • *****
  • Posts: 250
    • View Profile
Re: Lowercase/Uppercase Titles (Sort by Title)
« Reply #3 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.

Offline nostra

  • Administrator
  • *****
  • Posts: 2852
    • View Profile
    • Personal Video Database
Re: Lowercase/Uppercase Titles (Sort by Title)
« Reply #4 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...
Gentlemen, you can’t fight in here! This is the War Room!