I ran into a similar problem with one of my projects; people were using Greek
and Cyrillic letters and other symbols to be cute. It’s all in English, but
they kept doing things like using ß for B and ¥ for Y. And then expecting to
be able to search the way they way it looks. So I am doing the cleanup in the
.save() method. My only advice is to use
https://docs.python.org/3/library/stdtypes.html?highlight=translate#str.translate
instead of multiple replaces. If you make the translation map a global
variable, it is much faster.
- Peter of the Norse
> On Feb 15, 2018, at 5:55 AM, Mike Dewhirst <mi...@dewhirst.com.au> wrote:
>
>> 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.
--
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/65B863CA-7C6C-4DC7-83FC-DAE87D2F6E8C%40Radio1190.org.
For more options, visit https://groups.google.com/d/optout.
