HTML Character Codes and Unicode

I am pulling in data from a couple of external API’s which return text that I’m adding to my db. The problem is the text includes HTML Character Codes (eg. ” or ) and Unicode (eg. \u201d ) and I don’t know how to filter or replace them.

Please advise.

Yep, I’m also looking for a solution to this problem.