Re: [Django] #8384: Wrong alphabetical ordering with accented letters (sqlite issue?)
Django
-------------------------------------+-------------------------------------
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.
Django
-------------------------------------+-------------------------------------
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
-------------------------------------+-------------------------------------
Comment (by yesyves):
OK, my error, I have a default sort in my model. Sorry !
--
Ticket URL: <https://code.djangoproject.com/ticket/8384#comment:3>