Why Aren't My Emojis Saving Correctly in My MySQL utf8mb4 Database?

MySQL utf8mb4: Issues While Saving Emojis

This issue arises when attempting to save Unicode characters, such as emojis, into a MySQL database. Despite following online guides and configuring the database, table, and column properly, some emojis are not saved accurately.

Configuration Verification

To ensure proper configuration, the character set and collation of the database, table, and column should be set to utf8mb4 (_unicode_ci). Additionally, ensure that the following database-specific variables are set to utf8mb4: character_set_client, character_set_connection, and character_set_results.

Database-Specific Variables Adjustment

If these variables are not set correctly for the specific database, MySQL may not be able to store the emojis. To adjust these settings, one can execute the query:

ALTER DATABASE database_name CHARACTER SET = utf8mb4, COLLATE = utf8mb4_unicode_ci;

my.cnf File Configuration

Additionally, ensure the following lines are present in the my.cnf configuration file:

[mysql]
default-character-set = utf8mb4

[mysqld]
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci

Additional Considerations

• If the SET NAMES utf8mb4 query is executed, all three database-specific variables (character_set, _connection, and _results) will be set correctly.
• Emojis that are only 3-bytes long can be stored using utf8 encoding, explaining why the sun emoji was saved correctly.

The above is the detailed content of Why Aren't My Emojis Saving Correctly in My MySQL utf8mb4 Database?. For more information, please follow other related articles on the PHP Chinese website!