Making Django model Query case-insensitive

Question

I would like to look up users by their email without worrying about uppercase letters.

How would I do this? I tried

customer = Customer.objects.get(email__lower="test@gmail.com")

and got this error.

django.core.exceptions.FieldError: Unsupported lookup 'lower' for EmailField or join on the field not permitted.

Answer 1

You can work with the __iexact lookup ^[Django-doc]:

customer = Customer.objects.get(email__iexact='test@gmail.com')

Contrary to popular belief, calling lowercase over two items does not check if the two match in a case insensitive way. Some characters have no lowercase/uppercase variant, for example ß ^[wiki]. In order to determine if two strings match case-insensitive, one should apply a case folding ^[wiki].