在mysql中怎么存储表情符号,如何在MySQL数据库中存储表情符号字符

I am using Emoji character in my project. That characters are saved (??) into mysql database. I had used database Default collation in utf8mb4_general_ci.

It show

1366 Incorrect string value: '\xF0\x9F\x98\x83\xF0\x9F...' for column

'comment' at row 1

解决方案

1) Database: Change Database default collation as utf8mb4.

2) Table: Change table collation as CHARACTER SET utf8mb4 COLLATE utf8mb4_bin.

Query:

ALTER TABLE Tablename CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin

3) Code:

INSERT INTO tablename (column1, column2, column3, column4, column5, column6, column7)

VALUES ('273', '3', 'Hdhdhdh😜😀😊😃hzhzhzzhjzj 我爱你 ❌', 49, 1, '2016-09-13 08:02:29', '2016-09-13 08:02:29')

4) Set utf8mb4 in database connection:

$database_connection = new mysqli($server, $user, $password, $database_name);

$database_connection->set_charset('utf8mb4');