Re: Case Sensitivity on MySQL searches

>> It might even be as simple as tweaking the >> db/backends/mysql/base.py and changing the entry in the >> OPERATOR_MAPPING value from >> >>'exact': '= %s', >> >> to >> >>'exact': 'LIKE BINARY %s', > > This is exactly what "contains" does. Example:- > > Entry.objects.get(headline__contai

Re: Case Sensitivity on MySQL searches

> Having read in other posts about MySQL being case insensitive by > default, I have tried using the __exact method to force exact > matching, however, this still finds the alternative case version in > the table. Note there are no duplicates in the table on this field. > > Example: > x=Datatabl

Case Sensitivity on MySQL searches

I've encountered a problem whereby my searches in the database are not distinguishing between upper and lower case. Having read in other posts about MySQL being case insensitive by default, I have tried using the __exact method to force exact matching, however, this still finds the alternative ca