数据库:
将数据库默认集合更改为** utf8mb4 **.
2)表:
将表集合更改为** CHARACTER SET utf8mb4 COLLATE utf8mb4_bin **.
查询:
ALTER TABLE Tablename CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin
3)代码:
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)在数据库连接中设置utf8mb4:
$database_connection = new mysqli($server, $user,$password,$database_name);
$database_connection->set_charset("utf8mb4");