On Aug 13, 2006, at 9:57 AM, Jon Atkinson wrote: > I've noticed that my application changes case sensitivity in queries > depending on whether it is using MySQL or sqlite as the database > backend > > ... > If there a recommended way to deal with this? I want to avoid forcing > a certain scheme on the users (i.e., they can type the name in all > lowercase, uppercase or mixed, it doesn't matter).
By default, MySQL searches are case insensitive. So if you want all queries, regardless of backend, to search case insensitively, use this: user = User.objects.get(username__iexact=person) Don --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users -~----------~----~----~----~------~----~------~--~---
