CODEWITHSUNDEEP
mysqlemoji
George
George

Reputation: 1114

Emoji's in mysql turns to question marks

I am trying to insert emoji's into mysql but it turns to question marks, I have changed mysql connection server collation, database collation , table collation and column collation. I used these to change the items

# For each database:
ALTER DATABASE database_name CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
# For each table:
ALTER TABLE table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
# For each column:
ALTER TABLE table_name CHANGE column_name column_name VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

I have done all these but emoji's in mysql still show question marks. Please what should I do to make mysql show the emojis. Thanks in advance

Upvotes: 17

Views: 8528

Answers (2)

Vamshi
Vamshi

Reputation: 143

Little late to answer the question. But I hope it will be useful for others...

Above configuration makes the database tables to store utf8 encoded data. But, the database connection(JDBC) should be able to transfer the utf8 encoded data to client. For that the JDBC connection parameter charset should be set to utf8mb4.

Upvotes: 9

Thomas Rbt
Thomas Rbt

Reputation: 1538

The default encoding for inbound connections isn't set properly. DEFAULT CHARSET will return as utf8 however character_set_server will be something different.

So, Set default-character-set=utf8.

Upvotes: 0

Related Questions