首页 > 数据库 >MySQL插入数据报错:1366 Incorrect string value: '\xF0\xA0\xB9\xB3\xF0\xA0...' for column xx

MySQL插入数据报错:1366 Incorrect string value: '\xF0\xA0\xB9\xB3\xF0\xA0...' for column xx

时间:2023-03-31 11:12:46浏览次数:42  
标签:Incorrect xxxx utf8mb4 xA0 报错 MySQL xF0

[10501]SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xF0\xA0\xB9\xB3\xF0\xA0...' for column xxxx at row 1

是因为MySQL不能识别4个字节的 utf8 编码的字符,抛出了异常。

解决办法将字符类型换成改为 utf8mb4

数据库:

ALTER DATABASE `db_name` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

表:

ALTER TABLE `table_name` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

 

连接编码也改成 utf8mb4

 

标签:Incorrect,xxxx,utf8mb4,xA0,报错,MySQL,xF0
From: https://www.cnblogs.com/kjcy8/p/17275654.html

相关文章