2012-08-21, 11:35
Quote:@Millencolin007 : thanks for information but the problem with NOCASE is that it does not correctly handle Unicode, Android have a special collation named well UNICODE that is there for that but while in the docs they said it's not case sensitive since ICS it has now become case sensitive see : http://code.google.com/p/android/issues/detail?id=27053.
I have still not checked if it's still the case in Jelly Bean but since only 30% of my users are English from Google play stats I don't really know what collation to choose
All the android bugs I run into as well... just frustrating
Unicode would be the better solution if it works properly since äöü are still at the end if you use COLLATE NOCASE. And even if only 30% of the users are English from the statistics a much higher percentage listens to English music and most tracks don't start with special characters anyway.