I’m using codeigniter and trying to save 🚚 to a MYSQL database table
The error i’m getting is
Incorrect string value: '\xF0\x9F\x9A\x9A' for column 'post'
1) Ensure you’re using MYSQL 5.5 only then will you be able to change the collation to utf8mb4_something
2) Ensure table columns that are going to receive emoji have their collation set to utf8mb4_something
3) Edit your database.php config file
$db['default']['char_set'] = 'utf8mb4'; $db['default']['dbcollat'] = 'utf8mb4_unicode_ci';
Answered By – PK.
Answer Checked By – Gilberto Lyons (BugsFixing Admin)