Working with Emojis [MySQL GUIDE]

mysql emoji guide.md

How to enable emojis in MySQL database

TLDR:

• Set your database collation to utf8mb4_bin
• Set your table collation to utf8mb4_bin
• Source: https://stackoverflow.com/a/39465494/7800523

If you are using CodeIgniter

• Set the character set into utf8mb4 and DB collation to utf8mb4_bin
• Or you can just edit application/config/database.php like this

$db['default'] = array(
  # ...
  'char_set' => 'utf8mb4',
  'dbcollat' => 'utf8mb4_bin',
  # ...
);

If you are using DBForge Migrations

$this->dbforge->create_table('messages', FALSE, array('CHARACTER SET' => 'utf8mb4', 'COLLATE' => 'utf8mb4_bin'));