Comment 3 for bug 274466

Revision history for this message
Benjamin Kampmann (lightyear) wrote :

The right thing to do here would be to do an case insensitive order_by at the query time ( see [1]). Unfortunately storm does not have a support for that (yet).

There is also the other idea that would actually merge the albums and artists on database level: Use collate already for the table definition (as in [2]). The problem with that is, that it would only work on new created database. The migration of the old content would not work as ALTER TABLE does not support that kind of change in SQLite (see [3]). But that patch is at least very easy. I will attach it :) .

[1] http://<email address hidden>/msg26164.html
[2] http://www.realsoftware.com/listarchives/realbasic-nug/2006-08/msg00296.html
[3] http://www.sqlite.org/lang_altertable.html