Im doing some import of Facebook Post the Feeds module.
Im running into troubles with some mysql-error saying: SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xF3\xBE\x8C\xA7 M...' for column 'field_message_value' at row 1
I have located a post causing this issue:
https://graph.facebook.com/20446254070_10151404646659071?access_token= (From page facebook.com/businessinsider)
..- with the message-content:
"This flawless 101-carat diamond just sold for $26.7 million — http://read.bi/107CfXZ
Are you amazed more by the diamond or the hefty price tag?
(Photo: Christie's)"
Is it the dollar-sign causing some funky behaviour, or is it my databse which is weird.
My mysql is configures to default to utf8-character set all over.
I have tried to look what format the json sents the message with with mb_detect_encoding($entry->message), which just list ASCII and UTF-8 results.
Can any one point me in the direction of a solution for my issue?
Comments
Comment #1
Jooblay.net commented[reˈpuβlika ðel ekwaˈðor] Republic of Ecuador from the wikipedia page was causing this error through ckeditor.
The quick fix for us was just remove the characters.
Comment #2
megachrizSee #1428272: Added support of encoding conversions to the CSV Parser.