반응형
ERROR 1366 (HY000): Incorrect string value: '\xF0\x9F\x98\x9C' for column 'comment' at row 1
Here's my sql: INSERT INTO comments (createdate,userid,profileid,comment,status) VALUES (1449503167,65704,65704,'@Mr_S66 Wish I was There For The Xmas Party I Miss My Studio 66 Family 😜',15) ...
stackoverflow.com
PHP기준
$db = new PDO();
//charset 세팅
$db->exec("set names utf8mb4");
반응형
'데이터베이스 > MYSQL' 카테고리의 다른 글
| FUNCTION XXX.old_password does not exist (0) | 2023.12.13 |
|---|---|
| 서버이전후 ONLY_FULL_GROUP_BY (0) | 2023.12.13 |
| The server requested authentication method unknown to the client (0) | 2023.05.08 |
| Your password does net satisfy the current policy requirements (0) | 2021.05.07 |
| 현재시간 기본값설정 : CURRENT_TIMESTAMP (0) | 2020.05.15 |
