Django query __startswith is not case sensitive [duplicate]

I have been testing user searching with sorted results and I found this strange behavior

>>> User.objects.filter(username__istartswith="AbC")
<QuerySet [<User: AbC>, <User: AbCuuu>, <User: abc>, <User: abcuuu>]>
>>> User.objects.filter(username__startswith="AbC")
<QuerySet [<User: AbC>, <User: AbCuuu>, <User: abc>, <User: abcuuu>]>

Shouldn't __startswith only have 2 of those results? I need to actually search with case sensitivity, how do I do that?

I expect __startswith to be case sensitive and __istartswith to be case insensitive, but both return the same, case insensitive QuerySet

Back to Top