Yesterday after I uploaded one of the websites from local to staging I realized that most of the content was in some weird characters.
Ex: â€™, â„¢, œ
The content was full of these.
My normal release process is,
1- do the changes on localhost
2- upload to staging server and send to client for approval
3- upon approval upload the changes to live website
so basically what I do is upload the wp-content files from file-zilla and then export the local database to a external sql file and change all the links to staging/live versions and then run the script on staging or live server.
So these weird characters was coming in the exported file of the localhost. not in the website on local host it self.
After some researching I found that although my wordpress database was in utf-8 encoding the editor I use to change the links notepad++ is in ANSI encoding.
Solution – change encoding to utf-8 on notepad++
Problem solved. 🙂