如何在MySQL數(shù)據(jù)庫中存儲(chǔ)Emoji字符我在我的項(xiàng)目中使用了Emoji字符。角色被保存(？)進(jìn)入MySQL數(shù)據(jù)庫。中使用了數(shù)據(jù)庫默認(rèn)排序規(guī)則。utf8mb4_general_ci..它顯示1366不正確的字符串值：‘\xF0\x9F\x98\x83\xF0\x9F.’對(duì)于第1行的“注釋”一欄
3 回答
慕森王
TA貢獻(xiàn)1777條經(jīng)驗(yàn) 獲得超3個(gè)贊
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');
守著星空守著你
TA貢獻(xiàn)1799條經(jīng)驗(yàn) 獲得超8個(gè)贊
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;
添加回答
舉報(bào)
0/150
提交
取消