django-orm case-insensitive order by
Solution 1:
Since Django 1.8 it is possible with:
from django.db.models.functions import Lower
MyModel.objects.order_by(Lower('myfield'))
https://code.djangoproject.com/ticket/6498
Solution 2:
This answer is outdated, follow top voted solution with django >= 1.8
I found solution using .extra
class MyModelName(models.Model):
is_mine = models.BooleanField(default=False)
name = models.CharField(max_length=100)
MyModelName.objects.filter( is_mine=1 ).extra(\
select={'lower_name':'lower(name)'}).order_by('lower_name')
original link:
http://naorrosenberg.blogspot.fi/2011/04/django-models-orderby-charfield-case.html
Solution 3:
This is for postgresql, but maybe it will be useful for other databases too:
http://scottbarnham.com/blog/2007/11/20/case-insensitive-ordering-with-django-and-postgresql/