title: Matching special characters (e.g. #, +) using pg_search
body: <p>I'm using the pg_search gem in a Rails app to search against users - their bios and associated skill model. Users are developers, so their skills include things like "CSS", "C++", "C#", "Objective C", etc...</p>
  
  <p>I was initially using the the following search scope: </p>
  
  <pre><code>pg_search_scope :search,
    against: [:bio],
    using: {tsearch: {dictionary: "english", prefix: true}},
    associated_against: {user: [:fname, :lname], skills: :name}
  </code></pre>
  
  <p>However, if you search "C++" in this case, you'd get results that included "CSS" (among other things). I changed the scope to use the "simple" dictionary and removed prefixing: </p>
  
  <pre><code>pg_search_scope :search_without_prefix,
    against: [:bio],
    using: {tsearch: {dictionary: "simple"}}, 
    associated_against: {user: [:fname, :lname], skills: :name}
  </code></pre>
  
  <p>This fixed some things - for example, searching "C++" doesn't show "CSS". But, searching "C++" or "C#" still matches users who have "C" or "Objective C" listed</p>
  
  <p>I can definitely do a basic <code>ILIKE</code> match, but hoping to accomplish this using pg_search if possible.</p>