#21181: collation specific query results ordering
----------------------------------------------+--------------------
Reporter: alan.kesselmann@… | Owner: nobody
Type: New feature | Status: new
Component: Database layer (models, ORM) | Version:
Severity: Normal | Keywords: ORM
Triage Stage: Unreviewed | Has patch: 0
Easy pickings: 0 | UI/UX: 0
----------------------------------------------+--------------------
There has been feature request for it in 2012 in django-developers group :
https://groups.google.com/forum/#!topic/django-developers/0iESVnawNAY.
Before finding that request i asked about same thing in stackoverflow:
http://stackoverflow.com/questions/18935712/queryset-sorting-specifying-
column-collation-for-django-orm-query. Both Anssi
(https://groups.google.com/d/msg/django-
developers/0iESVnawNAY/JefMfAm7nQMJ) and me outline how it could be used
im same way:
.order_by([fieldnames], collation = 'et_EE')
another version of it could be automatical, based on django language
settings. Model often has ordering set in its Meta. So why not include
automatical ordering there too.
Is it possible to include this into some of next versions of Django?
'''Some background'''
If django is used to power some international site like a newspaper then
there is rarely need for sorting data based on sorting rules of language
other than english. If you use it to power a site that hosts data in
several languages then you have need to also display data in that language
properly. Sorting based on English alphabet does not work correctly in
that case cause letters missing from english alphabet (and there are MANY
of those letters that exist in swedish, danish, german, not to mention
estonian, russian etc. alphabets) are displayed in completely wrong
places.
Again - most django sites will be probably using single language. But
there are many cases that will benefit from this feature. Like e-commerce
modules, that translate product names - they can benefit from it. Any site
that allows language based naming or translating of their objects will
benefit from this feature.
--
Ticket URL: <https://code.djangoproject.com/ticket/21181>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/068.a06e3cfa1bcd3e7bf97ec91b86b9db8e%40djangoproject.com.
For more options, visit https://groups.google.com/groups/opt_out.
