Figured it out! When using the WebClient class, I was downloading the data as a string.
My Original Configuration...
System.Net.WebClient wc = new WebClient();
string htmlData = wc.DownloadString(myUri);
I tried to convert this data into a UTF-16...from it's current string, but since Microsoft operates in UTF-16, it had handled the conversion on its own.
Instead, I switched my approach to reading the actual byte[] array from the data like so...
System.Net.WebClient wc = new WebClient();
string htmlData = UTFConvert(wc.DownloadData(myUri));
private string UTFConvert(byte[] utfBytes)
{
byte[] isoBytes = Encoding.Convert(Encoding.UTF8, Encoding.Unicode, utfBytes);
return Encoding.Unicode.GetString(isoBytes);
}
This fixed the problem, and SQL correctly see's the accents in everything now. Yippee.
Cheers all, and thanks for your help!
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…