title: Convert Accents to raw data SQL
body: <p>I have a column( BLOB data) in which accents are used. I would like to search for all the rows have a particular accent( not all the accents and replace them, a particular one).</p>
  
  <p>Suppose I want to search <code>l'application Data</code></p>
  
  <p>I have used below query but it does not work.</p>
  
  <pre><code>select * 
  from "correspondence" s
  where dbms_lob.instr(s."__data", utl_raw.cast_to_raw('l'application Data')) &gt; 0 
  and "externalReferenceNumber"like' 20160929%' 
  and "callingapplication"=' CVM'  
  and rownum &lt; 5
  order by s."__id" desc ;
  </code></pre>
  
  <p>Could you please help? It seems by using below also it does not work.</p>
  
  <pre><code>utl_raw.cast_to_raw('l || char(146) ||application Data')
  </code></pre>