#8384: Wrong alphabetical ordering with accented letters (sqlite issue?)
-------------------------------------+-------------------------------------
Reporter: florent@… | Owner: nobody
Type: Uncategorized | Status: closed
Component: Database layer | Version: 1.0-beta
(models, ORM) |
Severity: Normal | Resolution: invalid
Keywords: ordering, | Triage Stage:
alphabetical, sqlite | Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by yesyves):
* ui_ux: => 0
* type: => Uncategorized
* severity: => Normal
* easy: => 0
Comment:
Hi
I'm not sure about this.
I have a table in which the objects are already sorted in the right order.
{{{
for p in Programme.objects.all()
}}}
will output names beginning with a unicode character (É in this instance)
at the end of the list, while
{{{
for p in Programme.objects.all().order_by('created')
}}}
will output them in the right order.
I get the same behaviour with sqlite3 and PostgreSQL.
Django 2.2 / Python 3.7.4
Thanks
--
Ticket URL: <https://code.djangoproject.com/ticket/8384#comment:2>
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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/084.9ba7fbff783dbe43dfc89e5f10e8fe44%40djangoproject.com.
