title: how to have Accent-insensitive filter in django with postgres?
body: <p>Hi I find that on postgres database, we can't configure default accent sensivity (on old mail exchanges).</p>
  
  <p>Is there a way to have a _icontains also insensitive to special caracters (é, è, à, ç, ï) or I must use postgres regex to replace both side with _iregex (ç->c, é->e ...)?</p>
  
  <p>edit:
  this question is old, and is kept for users of django before 1.8. For those using latest django versions, here the new way: <a href="https://docs.djangoproject.com/en/dev/ref/contrib/postgres/lookups/#std:fieldlookup-unaccent" rel="noreferrer">https://docs.djangoproject.com/en/dev/ref/contrib/postgres/lookups/#std:fieldlookup-unaccent</a></p>