I'm using mysql\_real\_escape\_string to escape a string before inserting it into my mysql database.

Everything's working fine, except that the character `’` is getting missed and turned into `Ã¢â‚¬â„¢` by mysql.

What can I do to get solve the problem? Should i be using a better function to escape the string? 

I'm also worried that other charachters might be getting missed and being similarly turned into nonsense!

Please help! 

Thanks :)