Re: Inserting emojis in MySql 5.6 DB using 5.1.32 connector
Posted by: Arati Rahalkar
Date: May 18, 2016 07:17PM

I am using mysql connector 5.1.32. And I am using Mysql 5.6.17 version with Amazon RDS.
With the RDS DB parameter group, I was able to set the character_set_server, character_set_client, character_set_database etc to utf8mb4 and corresponding collation to utf8mb4_unicode_ci.
But even though I set the character_set_client in the DB parameter group, it was falling back to utf8 on rebooting the DB instance.

Finally, what has worked for me is executing the "SET NAMES utf8mb4" statement before I do the insert call.

Options: ReplyQuote


Subject
Written By
Posted
Re: Inserting emojis in MySql 5.6 DB using 5.1.32 connector
May 18, 2016 07:17PM


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.