title: Rich text editor and Umlaute in Oracle Apex
body: <p>I have a table <strong>History</strong> that records changes to the application so that users know what's new and what's changed. Currently the changes are recorded manually through a rich editor and saved through an automatic insert process from Oracle Apex 18.2.</p>
  
  <p>I tested the following input through a normal insert in the Sqldeveloper:</p>
  
  <pre><code>insert into history_table
  (datum, beschreibung)
  values
  (sysdate, 'Test Umlaute : Ää - Aa; Üü - Uu; Öö - Oo');
  </code></pre>
  
  <p>The data shown on the Apex page is the following. It's the same when I selected it on the developer, as I expected:</p>
  
  <pre><code>Test Umlaute : Ää - Aa; Üü - Uu; Öö - Oo
  </code></pre>
  
  <p>When I try the same thing through the rich text editor and the automatic insert I receive the correct inserted data on the page, but this on the developer:</p>
  
  <pre><code>&lt;p&gt;Test Umlaute : &amp;Auml;&amp;auml; - Aa; &amp;Uuml;&amp;uuml; - Uu; &amp;Ouml;&amp;ouml; - Oo&lt;/p&gt;
  </code></pre>
  
  <p>Through using this code I can manage to replace it all, but only really in the query not if someone tries to download automatically through the website:</p>
  
  <pre><code>select regexp_replace(replace(replace(replace(replace(replace(replace(beschreibung, 'Auml', 'Ä'), 'auml', 'ä'), 'Uuml', 'Ü'), 'uuml', 'ü'), 'Ouml', 'Ö'), 'ouml', 'ö'), '&amp;|;|nbsp', '') beschreibung
  from history_table;
  </code></pre>
  
  <p>Is there a way to parse and replace the HTML identifiers somewhere in between the insert commands to the actual letters while the Rich Text Editor is still used?</p>