title: XML Character encoding to HTML
body: <p>I am generating XML/HTML from my SQL Query to be placed in my frontend.</p>
  
  <p>The problem is that the conversion from SQL > XML > HTML is not the same encoding.</p>
  
  <p>Each html tag generated by SQL has a class so I want convert the encoding to display correctly in my front using <strong>jQuery</strong>.</p>
  
  <p><em>Is there any good jQuery/Javascript function I can use to convert my generated html?</em></p>
  
  <p><strong>Example</strong></p>
  
  <pre><code>é
  </code></pre>
  
  <p>Will convert to:</p>
  
  <pre><code>ã© 
  </code></pre>
  
  <p>And I want to convert it back to it's normal state.</p>
  
  <p><strong>SQL Example:</strong> This is how I get my XML/HTML from SQL in my <em>SELECT Clause, column</em></p>
  
  <pre><code>htmlForFront = (SELECT ', ' + columnName + '' FROM tableName FOR XML path(''), elements) 
  </code></pre>
  
  <p><strong>NOTE:</strong></p>
  
  <p>It would be easier for me to implement if it's client side (<code>jQuery</code>). But if I have no other choice <code>C#</code> would be fine.</p>