mysql插入中文异常：Incorrect string value: ‘\xE5\xB0\x8F\xE9\xBE\x99...‘ for column ‘name‘ at row 1

2021-07-28 21:56:33

问题：插入中文的时候显示：Incorrect string value: '\xE5\xB0\x8F\xE9\xBE\x99...' for column 'name' at row 1

$mysql插入中文异常：Incorrect string value: ‘\xE5\xB0\x8F\xE9\xBE\x99...‘ for column ‘name‘ at row 1$

解决方法：找到mysql/my.ini 把字符集修改为uft8

$mysql插入中文异常：Incorrect string value: ‘\xE5\xB0\x8F\xE9\xBE\x99...‘ for column ‘name‘ at row 1$

如果还是不行找到你的table修改它的字符集

$mysql插入中文异常：Incorrect string value: ‘\xE5\xB0\x8F\xE9\xBE\x99...‘ for column ‘name‘ at row 1$

码农公寓