title: classic asp character encoding
body: <p>I'm having a problem with Spanish characters in a classic asp site. A user is able to submit their name/address in a form on an aspx page. The aspx page then does an ajax post to a classic asp page which all it does is stored in our Sql 2008 DB. I can see in the database that the character is not stored correctly. For example the first name looks like <code>MÂª</code> where it should be <code>Mª</code>.</p>
  
  <p>When I then read that data and display it in a text box it is still displaying <code>MÂª</code>. </p>
  
  <p>things I've tried:</p>
  
  <ul>
  <li><code>&lt;%@ Language=VBScript codepage=65001 %&gt;
  &lt;% Response.Charset="UTF-8" %&gt;</code></li>
  <li>encoding file as UTF-8 (using notepad++)</li>
  </ul>
  
  <p>any other ideas? Do I need to go back into the database and fix the characters first or can this be done when I read the characters and display them?</p>