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 case version in the table. Note there are no duplicates in the table on this field. Example: x=Datatable.objects.get(code__exact='AbCd') y=x.code print y 'AbcD' Can anyone advise on how I might overcome this issue. For our model, it is vital that we can identify distinct case sensitive entries. The field I'm looking up on is a varchar field in the table, in case this is relevant. MySQL v5. --~--~---------~--~----~------------~-------~--~----~ 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?hl=en -~----------~----~----~----~------~----~------~--~---
