Android Question Sort list with diacritical marks

johnmie

Active Member
Licensed User
Longtime User
Hi all,
my SQlite DB contains a mix of languages which is why métadonneés comes after multitasking in a list.
Is there a way to sort such lists correctly?
Thanks for your help,
john m.
 

mangojack

Well-Known Member
Licensed User
Longtime User
Upvote 0

johnmie

Active Member
Licensed User
Longtime User
Thank you, Mangojack for the tip,
very useful but it would make things a lot more complicated since the list.value is used to search in the db, i.e. I would have to maintain two parallel lists (with anywhere from 500 to 5000 entries).

Also depending on the typeface and language used, there could be hundreds of letters (UTF-8) concerned and I don't know the sorting rules for the other languages. I only know English, French, German, Italian, Spanish and Swedish and I don't know what constitutes an accent in Slovak or in the Cyrillic font.
In French é comes immediately after e, but in Swedish Å comes at the end of the alphabet.

Maybe there is a java library out there that can handle this dilemma.

Best, john m.
 
Upvote 0
Cookies are required to use this site. You must accept them to continue using the site. Learn more…