How to Fix MYSQL Error Character Insert into columns

December 26, 2020 23 sec read

saat saya menjalankan query terdapat error sebagai berikut:

setelah saya telusuri

https://stackoverflow.com/questions/34165523/error-1366-hy000-incorrect-string-value-xf0-x9f-x98-x9c-for-column-comme

kemudian edit sql pada tabel yang bersangkutan

ALTER TABLE issue_issue CONVERT TO CHARACTER SET utf8mb4;

ALTER TABLE issue_issue 
CHANGE COLUMN division_api division_api TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

atau

ALTER DATABASE issue CHARACTER SET = utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE issue_issue CONVERT to CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE issue_issue CHANGE division_api division_api LONGTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;