On Friday, 9 December 2011 05:04:23 UTC, ziggi wrote:
>
> Hi!
>
> I found only way to ordering query results ignorecase by using :
>
> Spam.objects.extra(select={'eggs_upper':'uppper(eggs)',order_by['eggs_upper']})
>
> Maybe has another way to do this?
>In MySQL, you can set the collation of your table to be case-insensitive. This affects all queries, though. -- DR. -- You received this message because you are subscribed to the Google Groups "Django users" group. To view this discussion on the web visit https://groups.google.com/d/msg/django-users/-/xT-661H8jyIJ. To post to this group, send email to django-users@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
