来自MySQL的Unicode字符（表情符号）显示为“????”

Question

On a MySQL table, the column release_notes is encoded in utf8mb4.

On the Laravel config/database.php file, the following is under the MySQL section:

'charset'   => 'utf8mb4',
'collation' => 'utf8mb4_unicode_ci',

From a MySQL client, I set the value of that column to an emoji (e.g. "

Answer 1

Exactly 4 question marks? The Emoji is 4 bytes long. The likely cause is trying to transform non-latin1 characters into a CHARACTER SET latin1 column.

Check all these:

• The column(s) in the database -- Use SHOW CREATE TABLE to verify that they are explicitly set to utf8, or defaulted from the table definition. (It is not enough to change the database default.)
• The connection between the client and the server. See SET NAMES utf8.
• The bytes you have. (This is probably the case.)
• If you are displaying the text in a web page, check the <meta> tag.