On 15/02/2018 10:19 PM, Hanne Moa wrote:
On 2018-02-06 12:51, Mike Dewhirst wrote:
Thank you. I think this is where we probably need to go. I asked the original 
question because I'm hoping the project will reach a tipping point and start to 
accumulate a growing number of multilingual users. We have our first 
multinational user but they only operate in the English speaking world so no 
pressure at the moment.
There can be no sort that satisfies every possible language at the same time. For instance, Norwegian sorts "ä" as "a" and 
"ö" as "o". Swedish sorts them after "å" as separate letters: åäö. Then there is Turkish where "i" sorts 
differently from "ı" (dotless i).

That is interesting! It says to me that longer term I need to think about special sort orders for different languages. A bit above my pay grade just now.

I've worked the greek letter prefixes by using a separate sort field only seen by the software. A simple replace('α', 'a') lets me adjust sort order for the moment. That may work with diacritics for some time. I'll be driven by actual requirements until I hit a brick wall and then I'll ask for PhD help :)

Thanks

Mike

I'm guessing chemistry names follow their own rules, you could see how hard it 
is to make your own os collation table and use that? Then everything running on 
the server would sort by the same rules.
HM


--
You received this message because you are subscribed to the Google Groups "Django 
users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/bfd1633b-a651-fec9-6f2a-86efac8d2e8c%40dewhirst.com.au.
For more options, visit https://groups.google.com/d/optout.

Reply via email to