All Emoji Not Stored in Mysql Database
Posted by: RANJIT SONI
Date: October 26, 2017 03:02AM


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.

Options: ReplyQuote

Written By
All Emoji Not Stored in Mysql Database
October 26, 2017 03:02AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.