title: icontains in Django QuerySet doesn't give the case insensitive result?
body: <p>I am using Django1.6, I am trying to use QuerySet filter, but it is behaving strangely.</p>
  
  <p>Here is my code:</p>
  
  <pre><code>test_listing = Test.objects.filter(site__id=_site_id, show_on_site=True)
  </code></pre>
  
  <p>Then I am trying to get the listing based on the searched text:</p>
  
  <pre><code>test_listing = test_listing.filter(name__icontains = searched_text)
  </code></pre>
  
  <p>I am using MySQL as database for my project.</p>
  
  <p>When I search for 'foo' it returns a blank list, but when I search for 'FOO', it returns the list of objects where there is an entry of FOOBAR as a name in my Test table.</p>
  
  <p>Why is it behaving so strangely...?</p>