Emojis in the database

Here is what you need to do in order to store and retrieve text with emojis in the database. This tutorial applies to PHPRunner 10.91 and MySQL.

1. Create database and database tables. Important: use charset utf8mb4 and collation utf8mb4_unicode_ci when you create database and tables. It is also possible to change the collation of existing database but in out example we will show how to

Create database:
CREATE DATABASE emoji DEFAULT CHARSET = utf8mb4 DEFAULT COLLATE = utf8mb4_unicode_ci;

Create database table:

2. In PHPRunner make sure that "Unicode (UTF-8)" is selected as Output Code Page on Miscellaneous screen.

   
   

3. Add the following code to AfterAppInit event
   $cMySQLNames = "utf8mb4";

   
   

And the end result: