remove weird characters

I have imported the wordpress database and full source and implemented in my local server. I started working on it and i have also updated the wordpress 开发者_如何学Pythonversion and also the plugins.

now the problem is that there are weird characters coming in my posts. such as ’ instead of '. So now shall i remove this from everywhere now. i have lots of posts and i dont want to do laborious work. can we have fire some query on wordpress database and remove this character..

Try to change the database collation to UTF-8-GENERAL

charset in MySQL