title: xml parsing utf-8 characters in oracle
body: <p>I have an xml file with node </p>
  
  <pre><code>&lt;formatted_address&gt;
    Selimiye Mh., Vehbi Koç Acil Tıp Mrk., 34660 Üsküdar/İstanbul, Turkey
  &lt;/formatted_address&gt;
  </code></pre>
  
  <p>My oracle code is looks like this </p>
  
  <pre><code>  select xmlsequence(v_xml_resp.extract('/result')) into nodelist from dual;
  Extracting "address" node
       node.extract('//address/text()').getstringval();
  </code></pre>
  
  <p>The extracted node value looks like this
      Selimiye Mh., Vehbi KoÃ§ Acil TÄ±p Mrk., 34660 ÃskÃ¼dar/Ä°stanbul, Turkey</p>
  
  <p>Any idea how to fix this</p>
  
  <p>Thanks</p>