title: Postgres accent insensitive LIKE search in Rails 3.1 on Heroku
body: <p>How can I modify a where/like condition on a search query in Rails:</p>
  
  <p><code>find(:all, :conditions =&gt; ["lower(name) LIKE ?", "%#{search.downcase}%"])</code></p>
  
  <p>so that the results are matched irrespective of accents? (eg métro = metro). Because I'm using utf8, I can't use "to_ascii". Production is running on Heroku.</p>