Here is my row data:
A windy day looking at open houses ðŸÂ‚ðŸÂÂðŸÂ‚ðŸÂÂðŸÂ‚ðŸÂ https://t.co/8PCAMxJYaG
I need to convert the character encoding here to be a readable format.
I'm not quite sure how to accomplish this, possibly using php.
Any help would be appreciated.
Make sure that your database collation is correct. For accentuated values latin-1 collation is your choice.
If it's right, mind sanitize your input and connection charset.
Cheers!