All Emoji Not Stored in Mysql Database
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.
Subject
Views
Written By
Posted
All Emoji Not Stored in Mysql Database
6571
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.