title: regexp for all accented characters in Oracle
body: <p>I am trying to find data that has accented characters. I've tried this:</p>
  
  <pre><code>select *
  from xml_tmp
  where regexp_like (XMLTYpe.getClobVal(xml_tmp.xml_data), unistr('\0090'))
  </code></pre>
  
  <p>And it works. It finds all records where the XML data field contains É. The problem is that it only matches the upper-case E with an accent. I tried to write a more generic query to find ALL data with accented vowels (a, e, i, o, u, upper and lowercase, with any accents) using equivalence classes. I wanted a regex to match <em>only</em> accented vowels, but I'm not sure how to get it, as equivalence classes such as <code>[[=e=]]</code> match <em>all</em> e's (with or without accents).</p>
  
  <p>Also,  this does not actually work:</p>
  
  <pre><code>select *
  from xml_tmp
  where regexp_like (XMLTYpe.getClobVal(xml_data),'É');
  </code></pre>
  
  <p>(using Oracle 10g)</p>