I'm scraping the text from websites and putting it in a database, but one website's text keeps giving me this error when I try to do the database insertion:
Error: ER_TRUNCATED_WRONG_VALUE_FOR_FIELD: Incorrect string value: '\xC2\x80\xC2\x99 s...' for column 'text' at row 1
I fixed this by adding 'charset : utf-8' to the mysql connection parameters.
There is currently no discussion for this recipe.
This recipe can be found in it's original form on Stack Over Flow.