python - 内部错误 : 1366

Question

我正在尝试为学校项目制作网络爬虫。当我尝试抓取某些网站时，出现以下错误:

Incorrect string value: '\xC4\x82\xC5\xA4 \xC3...' for column 'content' at row 1

表格内容的配置如下所示

CREATE TABLE IF NOT EXISTS scotchbox.content (
  id INT(11) NOT NULL AUTO_INCREMENT,
  url INT(11) NOT NULL,
  content LONGTEXT CHARACTER SET 'utf8' NOT NULL,
  content_raw LONGTEXT CHARACTER SET 'utf8' NOT NULL,
  content_raw_hash VARCHAR(255) CHARACTER SET 'utf8' NOT NULL,
  PRIMARY KEY (id),
  INDEX idx_content__url (url ASC),
  CONSTRAINT fk_content__url
    FOREIGN KEY (url)
    REFERENCES scotchbox.url (id))
ENGINE = InnoDB
AUTO_INCREMENT = 4
DEFAULT CHARACTER SET = utf8mb4;

谁能告诉我需要更改/做什么才能将页面导入数据库？

Answer 1

我相信这会帮助您解决上一个问题的问题。

How to fix "Incorrect string value" errors?