何在MySQL數據庫中存儲Emoji字符我在我的項目中使用了Emoji字符。角色被保存(？)進入MySQL數據庫。中使用了數據庫默認排序規則。utf8mb4_general_ci..它顯示1366不正確的字符串值：‘\xF0\x9F\x98\x83\xF0\x9F.’對于第1行的“注釋”一欄
3 回答
慕妹3242003
TA貢獻1824條經驗 獲得超6個贊
utf8mb4.
CHARACTER SET utf8mb4 COLLATE utf8mb4_bin.
ALTER TABLE Tablename CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin
INSERT INTO tablename (column1, column2, column3, column4, column5, column6, column7)VALUES ('273', '3', '
Hdhdhdhhzhzhzzhjzj 我愛你 ', 49, 1, '2016-09-13 08:02:29', '2016-09-13 08:02:29')utf8mb4
$database_connection = new mysqli($server, $user, $password, $database_name);
$database_connection->set_charset('utf8mb4');
qq_遁去的一_1
TA貢獻1725條經驗 獲得超8個贊
ALTER DATABASE database_name CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS table_name (...) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;ALTER TABLE table_name modify name text charset utf8mb4;
添加回答
舉報
0/150
提交
取消