Elisa db sorts case sensitive
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Moovida |
Fix Released
|
High
|
Philippe Normand |
Bug Description
The database sorting is case sensitive. That means that first all objects with a their first letter uppercase and then all with the first letter beeing lowercase are shown.
To be able to reproduce this, make sure you have at least one mp3 with tags (artist and or album) that do *not* start with an uppercase letter in your music collection that is scanned with the media scanner.
Steps to reproduce:
- Start elisa go into your music library
- wait for the media scanner to be done
- select either Albums or Artists (the one where you know you have lowercase tag informations)
- use the scroll bar to scroll to the last letter in your collection
Expected result:
- behind that letter are only a few entries for Umlaute (aka. non-alphanumeric letters)
Current result:
- you find a lot of entries that are just lowercased, they are not sorted into the list right
See the screenshots, too
Related branches
Changed in elisa: | |
importance: | Undecided → High |
milestone: | none → 0.5.x |
Changed in elisa: | |
milestone: | 0.5.x → 0.5.99 |
Changed in elisa: | |
assignee: | nobody → Philippe Normand (philn) |
status: | New → In Progress |
Changed in elisa: | |
milestone: | 0.5.99 → none |
status: | In Progress → Fix Released |
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 www.realsoftwar e.com/listarchi ves/realbasic- nug/2006- 08/msg00296. html www.sqlite. org/lang_ altertable. html
[2] http://
[3] http://