All Emoji Not Stored in Mysql Database

[RANJIT SONI]

Hi,

To store emoji, i have done following configuration in ini configuration file.

DB Activity for Storing Emojis
-----------------------------------------
1) default-character-set = utf8mb4 under [client]
2) default-character-set = utf8mb4 under [mysql]

3) Following under [mysqld]
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci

4) Restart Mysql server using below command
sudo service mysql stop
sudo service mysql start
5) ALTER DATABASE database_name CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
6) ALTER TABLE table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
7) SET NAMES utf8mb4;

Initially Emoji sent by Android application was getting stored in Mysql Database in Development environment but same is not working in Production environment.

Please help.
Thanks in Advance.