I am trying to store emojis in MySQL database by changing to utf8mb4.
I have changed the charset and collation of the database, table and column, but it still does not work. I get the following message when trying in phpmyadmin:
Warning: #1300 Invalid utf8 character string: '\xF0\x9F \x98\x84
Indicating that UTF8 is still the charset somewhere. But I am 95% sure the table and column has utf8mb4.
I am guessing the problem is because I need to also change the charset configs in the my.cnf file? Problem is I do not have access to this file through my host (not dedicated)
character_set_client utf8
character_set_connection utf8mb4
character_set_database utf8mb4
character_set_filesystem binary
character_set_results utf8
character_set_server latin1
character_set_system utf8
collation_connection utf8mb4_unicode_ci
collation_database utf8mb4_unicode_ci
collation_server latin1_swedish_ci
Is there anything I can do on my side, through phpmyadmin for example? Have I missed something?