If I'm scraping the url of a website with an accented character such as é in it, what's the best way to store it in my mysql database so that when it is retrieved and displayed on screen it shows é instead of %C3%A9
I'm using utf8. When I scrape actual web data it is stored in my database as é and it displays fine, it's only when I'm scraping urls that I have issues.