|
|
Post by M on Feb 24, 2014 14:51:16 GMT -5
I have an Islandic interpret named 'Ásgeir'. When browsing by interprets the artist is listed below character 'Z'. I know why it is like it is, however, it would be a good idea to see him in the list near by 'A'.
|
|
|
|
Post by GoneMAD on Feb 24, 2014 17:36:17 GMT -5
I have an Islandic interpret named 'Ásgeir'. When browsing by interprets the artist is listed below character 'Z'. I know why it is like it is, however, it would be a good idea to see him in the list near by 'A'. sqlite (the database technology) unfortunately does not allow for this as far as i know |
|
|
|
Post by M on Feb 25, 2014 15:45:56 GMT -5
Hhm, well - agreed. Seems to be a bit complex. One would need to know the locale in order to sort properly. For instance, in some languages characters with an accent are more or less the same character just with a different pronounciation. In other languages characters with an accent might become a totally new character. The Islandic alphabet is listing character 'Á' just behind 'A' whereas the Danish alphabet is listing 'Å' behind 'Z' as a separate letter. I wasn't aware of that.
After having asked mighty google, I ran across ICU, an 'International Components for Unicode' library providing globalization support even for sqlite. Would that be a way out? (Not to be misunderstood: I could live with the way gmmp is sorting right now. This feature request has only been a minor one. But as I'm curious: Any idea?)
|
|
|
|
Post by GoneMAD on Feb 25, 2014 18:47:52 GMT -5
Hhm, well - agreed. Seems to be a bit complex. One would need to know the locale in order to sort properly. For instance, in some languages characters with an accent are more or less the same character just with a different pronounciation. In other languages characters with an accent might become a totally new character. The Islandic alphabet is listing character 'Á' just behind 'A' whereas the Danish alphabet is listing 'Å' behind 'Z' as a separate letter. I wasn't aware of that. After having asked mighty google, I ran across ICU, an 'International Components for Unicode' library providing globalization support even for sqlite. Would that be a way out? (Not to be misunderstood: I could live with the way gmmp is sorting right now. This feature request has only been a minor one. But as I'm curious: Any idea?) Sqlite on android is not compiled with the ICU extension unfortunately. stackoverflow.com/questions/7070193/is-sqlite-on-android-built-with-the-icu-tokenizer-enabled-for-fts If google decides to add that in it should be fairly easy to incorporate |
|
