[SOLVED] How do I store unicode emoji to MYSQL in CodeIgniter

Issue

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'

Solution

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)

Leave a Reply

Your email address will not be published.