As of http://code.djangoproject.com/changeset/7798 in the MySQL DatabaseWrapper.operations, Malcolm has changed the "__exact" filter to use '= BINARY' to force case-sensitive comparisons, which is appropriate.
I therefore propose that operations."__iexact" should be changed from 'LIKE %s' to '= %s', which performs much better, and gives the same results for the cases which the documentation specifically describes: "Case-insensitive exact match". There's no reason to be using LIKE here when the database gives us a better built-in option for the same behavior. Thoughts? George --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-developers?hl=en -~----------~----~----~----~------~----~------~--~---
