Sqlalchemy 乱码解决方法

最新推荐文章于 2024-05-31 14:08:21 发布

weixin_33674976

最新推荐文章于 2024-05-31 14:08:21 发布

阅读量652

点赞数 1

文章标签：数据库 python json

原文链接：https://my.oschina.net/phybrain/blog/2998407

版权

2019独角兽企业重金招聘Python工程师标准>>>

from sqlalchemy import create_engine, Column, Integer, String, BigInteger
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker

engine = create_engine('mysql://root:123456@111.231.60.147/test?charset=utf8', max_overflow=5, echo=True, encoding='utf-8',convert_unicode=True)

连接时同时设置charset=utf8', 和 encoding='utf-8' 否则还是会乱码

class Bill(Base):
    __tablename__ = 'bill_image_info'
    id = Column(BigInteger, primary_key=True)
    bboxs = Column(String(100))
    bill_type = Column(String(20))
    url = Column(String(30))
    __table_args__ = {
        "mysql_charset": "utf8"
    }

表里设置编码

转载于:https://my.oschina.net/phybrain/blog/2998407