title: Problem with U+02BB character in SQL server LIKE search
body: <p>My SQL table has rows like</p>
  
  <pre><code>Hawaiʻi 
  01
  abcʻdef
  ʻabc
  abcʻ
  </code></pre>
  
  <p>All "apostrophes" are actually okina characters (U+02BB)</p>
  
  <p>When I use the following search statement</p>
  
  <pre><code>select text01 from atable where text01 like N'%ʻ%'
  </code></pre>
  
  <p>I get all rows returned, even "01"</p>
  
  <p>ESCAPE clause (e.g. LIKE N'%!ʻ%' ESCAPE '!') does not help</p>
  
  <p>SQL Server 2005 SP3</p>
  
  <p>Any ideas?</p>