Post reply

Warning: this topic has not been posted in for at least 120 days.
Unless you're sure you want to reply, please consider starting a new topic.

Note: this post will not display until it's been approved by a moderator.

Name:
Email:
Subject:
Message icon:
Attach:
(Clear Attachment)
(more attachments)
Allowed file types: gif, jpg, png, txt, tpl, lng, ini, pvd, psf, ini, cfg, csv, zip, xml, pas, 7z
Restrictions: 4 per post, maximum total size 1024KB, maximum individual size 1024KB
Note that any files attached will not be displayed until approved by a moderator.
Verification:
Type the letters shown in the picture
Listen to the letters / Request another image

Type the letters shown in the picture:
What is the best video database software?:

shortcuts: hit alt+s to submit/post or alt+p to preview


Topic Summary

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