Discuss / SQL / ERROR 1366 (HY000) at line 29: Incorrect string value: '\x80\xE7\x8F\xAD' for column 'name' at row 1
Back

ERROR 1366 (HY000) at line 29: Incorrect string value: '\x80\xE7\x8F\xAD' for column 'name' at row 1

Topic source

Enhancer_

#1 Created at ... [Delete] [Delete and Lock User]

直接复制语句保存为txt文件（编码是utf8）再改名为init-test-data.sql，然后cmd中使用命令

mysql -u root -p < init-test-data.sql

报错：

ERROR 1366 (HY000) at line 29: Incorrect string value: '\x80\xE7\x8F\xAD' for column 'name' at row 1

一行一行复制到SQL命令行那里运行却成了

  • 1

Reply