title: Repair bad character due to encoding problem
body: <p>Recently we had an encoding problem in our system :</p>
  
  <p>If we had the string "æ" in our db ,it became "Ã¦" on our web pages.</p>
  
  <p>Now this problem is solved, but the problem is that now we have a lot of "Ã¦" in our database : users didn't see and validate pre-filled form with these characters.</p>
  
  <p>I found that If you read in utf 8 C3A6 you'll get "æ", if you read it in ascii you'll get "Ã¦".</p>
  
  <p>It's strange because if I execute</p>
  
  <pre><code>"select convert(varbinary(40),N'æ'),convert(varbinary(40),'Ã¦')"
  </code></pre>
  
  <p>I don't have the same result...</p>
  
  <p>Do you have any idea on how I can fix my database (ie change all "Ã¦" to "æ") ?</p>
  
  <p>thx</p>