在navicat里面提示:1366 Incorrect string value:‘xxx’ for column ‘xx’ at row 1 代码提示: pymysql.err.DataError: (1366, “Incorrect string value: ‘xx.’ for column ‘xx’ at row 1”) 问题是因为编码问题,字符串设置varchar里面的编码为latin1, 解决方案是:如下图所示,在navicat里面改为utf8即可