thomaszhwang
asked on
Strange strings that cannot be inserted into a table
I'm collecting some random tweets. For some of the tweets, I failed to insert their body into a MySQL database. Following is the error message I received.
Here is the tweet body.
I believe it's because of the squares. The collation of the database is utf8 - default collation.
Thanks.
Incorrect string value: '\xF0\x9F\x91\xAF\xF0\x9F...' for column 'tweetBody' at row 1
Here is the tweet body.
Tell Tyga look for this chick called black china sill a nigga bitch ???? In a hot flash ?? menopause hot flash
I believe it's because of the squares. The collation of the database is utf8 - default collation.
Thanks.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER