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

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.

Options: ReplyQuote


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