Utf8mb4 (emojis) in MySQL without access to my.cnf

452 views Asked by At

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?

0

There are 0 answers