AnsweredAssumed Answered

Errors importing Canvas Data

Question asked by Joni Miller Expert on Apr 5, 2016
Latest reply on Apr 12, 2016 by Joni Miller

Has anyone run into errors when importing data into MySQL database using the data types on the schema? 

 

I've had this error for the following tables/fields

conversation_message_dim.body (longtext)

discussion_entry_dim.message (longtext)

discussion_topic_dim.message (longtext)

submission_comment_dim.comment (longtext)

submission_dim.body (longtext)

 

I'm getting errors such as this: 

 

Query OK, 32959 rows affected, 11 warnings (3.14 sec)

Records: 32959  Deleted: 0  Skipped: 0  Warnings: 11

  Level: Warning

   Code: 1366

Message: Incorrect string value: '\xF0\x9F\x98\x80</...' for column 'message' at row 10471

Outcomes