title: Correcting text in database?
body: <p>Question:</p>
  
  <p>In one of my database, there is a value in a varchar-field:
  Brokers MÃ©xico, Intermediario de Aseguro,S.A.</p>
  
  <p>Now I make a new column as nvarchar, and want to take over the old values, properly encoded.</p>
  
  <p>Now two questions:<br /><br />
  A)<br />
  In C#/VB.NET, how can I change MÃ©xico back to the proper value ("México"), before storing it in the unicode field (assuming I know the proper source-codepage)?</p>
  
  <p>B)<br /> 
  Is there a way to figure out the codepage, if I don't want to do it manually ? (well, asking is free, but I suppose there is none).</p>