id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
2170	db lookup methods not case sensitive on mysql	derelm	Philippe Raoult	"i noticed that the methods `field__exact` and `field__iexact` match case insensitive on mysql
given you have a field (choices=(('a','small a'),('A','capital a'))) `field__exact` will always match both choices.

possible solution:
in django.db.backends.mysql.base
{{{
OPERATOR_MAPPING = {
    'exact': '= BINARY %s',
    ...
}
}}}
oh and will iexact, icontains, istatswith, iendswith all match exactly the same rows anyways?"	defect	closed	Database layer (models, ORM)	dev	normal	wontfix			Unreviewed	1	0	0	0	0	0