RSS apostrophe problem
===

I'm building an automated RSS feed in ASP.NET and occurrences of apostrophes and hyphens are rendering very strangely:

> "Here's a test" is rendering as "Hereâ€™s a test"

I have managed to circumvent a similar problem with the pound sign (£) by escaping the ampersand and building the HTML escape for `&pound;` manually as shown in in the extract below:

    sArticleSummary = sArticleSummary.Replace("Â£", "&amp;pound;")

But the following attempt is failing to resolve the apostrophe issue, we stil get `â€™` on the screen. 

    sArticleSummary = sArticleSummary.Replace("â€™", "&amp;#146;"")

The string in the database (SQL2005) for all intents and purposes appears to be plain text - can anyone advise why what seem to be plain text strings keep coming out in this manner, and if anyone has any ideas as to how to resolve the apostrophe issue that'd be appreciated. 

Thanks for your help.