Solving "General error: 1366 Incorrect string value: '\xF0\x9F\x91\x90 #...' for column xxx" in mysql

Posted 4 years ago - updated 4 years ago mysql

Check your character set in the field, you may need utf8mb4

ALTER TABLE `table` CHANGE `field` `field` LONGTEXT  CHARACTER SET utf8mb4  NULL;

Failing that, you may also want to convert to a blob:

ALTER TABLE `table` CHANGE `field` `field` LONGBLOB  NULL;