TA貢獻(xiàn)1946條經(jīng)驗(yàn) 獲得超4個(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 我愛(ài)你 ', 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)1798條經(jīng)驗(yàn) 獲得超3個(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)