Well - someone on #Django told me to check encoding settings and I did but I failed to read the following: http://dev.mysql.com/doc/refman/5.0/en/case-sensitivity.html
Using binary collation changes the default sensitivity of string comparisons. Is this not something that Django should be abstracting away? On Oct 16, 7:10 pm, "Ronny Haryanto" <[EMAIL PROTECTED]> wrote: > On Fri, Oct 17, 2008 at 12:55 AM, AndyB <[EMAIL PROTECTED]> wrote: > > I've googled and the only problems seem to be with people trying to do > > case-sensite lookups. > > > What could be going wrong here?: > > >>>> b.filter(name__icontains='Saff') > > [<Building: 27276: Saffron Court>] > >>>> b.filter(name__icontains='saff') > > [] > > Could you do: > > from django.db import connection > connection.queries > > to see the raw SQL queries? > > Ronny --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
