SQLAlchemy 和 UnicodeDecodeError

2021-12-30 00:00:00 python unicode sqlalchemy encoding mysql

我要了

UnicodeDecodeError: 'ascii' codec can't decode byte 0xc2 in position 0: ordinal not in range(128)

当我将来自我使用 SQLAlchemy 访问的 MySQL 数据库的文本传递给这个函数时:

when I pass text coming from a MySQL database, which I am accessing using SQLAlchemy, to this function:

re.compile(ur"<([^>]+)>", flags=re.UNICODE).sub(u" ", s)

数据库编码为 utf-8,我什至将编码传递给 SQLAlchemy 的 create_engine 函数.

The database encoding is utf-8 and I am even passing the encoding to the create_engine function of SQLAlchemy.

这是我查询数据库的方式:

This is how I am querying the database:

doc = session.query(Document).get(doc_id)
s = doc.title

根据建议,我将 s.decode('utf-8') 传递给 sub .上面的错误消失了,但对于不同的文档,我得到了不同的错误:

By suggestion, I passed s.decode('utf-8') to sub . The error above disappeared, but I get a different error for a different document:

UnicodeDecodeError: 'utf8' codec can't decode byte 0xeb in position 449: invalid continuation byte

数据库表定义如下:

CREATE TABLE `articles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `cdate` datetime DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL,
  `content` text,
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `link_idx` (`link`)
) ENGINE=InnoDB AUTO_INCREMENT=4127834 DEFAULT CHARSET=utf8;

任何帮助将不胜感激

推荐答案

我已经解决了这个问题.title 列由 SQLAlchemy 作为 str 而不是 Unicode 返回.我认为将 encoding='utf8' 作为参数添加到 create_engine 会解决这个问题,但是,正确的方法是将它传递到数据库 URI 中:mysql://me@myserver/mydatabase?charset=utf8 .

I have solved the issue. The title column was being returned by SQLAlchemy as a str and not Unicode. I thought adding encoding='utf8' as an argument to create_engine would take care of this, however, the right way to do it is to pass it in the database URI: mysql://me@myserver/mydatabase?charset=utf8 .

感谢您的所有回答!

相关文章