CODEWITHSUNDEEP
phpmysql
BN83
BN83

Reputation: 902

Emojis from MySQL database showing up as '?'

In my Phorum database I have changed the collation to utf8mb4_general_ci and successfully got emojis stored in the message body, however when you try to load the message it just displays a single '?'

Could this be an issue with the character set in use? I've found this:

// The charset to use for displaying special characters.
$PHORUM["DATA"]['CHARSET']="UTF-8";

Upvotes: 0

Views: 310

Answers (1)

Jack Albright
Jack Albright

Reputation: 509

According to this page:mathiasbynens.be, "MySQL’s utf8 charset only partially implements proper UTF-8 encoding. It can only store UTF-8-encoded symbols that consist of one to three bytes; encoded symbols that take up four bytes aren’t supported."

To execute this sql in mysql: ALTER DATABASE database_name CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;

Upvotes: 1

Related Questions