Python ORM SQLAlchemy 的中文乱码问题解决

最新推荐文章于 2023-04-30 22:15:00 发布

yypsober

最新推荐文章于 2023-04-30 22:15:00 发布

阅读量1.6k

点赞数

CC 4.0 BY-SA版权

分类专栏： Python MySql

本文链接：https://blog.youkuaiyun.com/yypsober/article/details/50818480

Python 同时被 2 个专栏收录

31 篇文章

订阅专栏

MySql

14 篇文章

订阅专栏

本文介绍了如何处理Python ORM SQLAlchemy在操作数据库时遇到的中文乱码问题，提供了三种方法：1)通过URL字符串添加查询参数`?charset=utf8`；2)利用`connect_args`传递非字符串类型参数；3)自定义返回DBAPI连接的callable函数。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Custom DBAPI connect() arguments

Custom arguments used when issuing the connect() call to the underlyingDBAPI may be issued in three distinct ways. String-based arguments can bepassed directly from the URL string as query arguments:（第一种方式URL query string：加上"?charset=utf8"）

 
  db = create_engine('postgresql://scott:tiger@localhost/test?argument1=foo&argument2=bar') 
 

If SQLAlchemy’s database connector is aware of a particular query argument, itmay convert its type from string to its proper type.

create_engine() also takes an argument connect_args which is an additional dictionary that will be passed to connect(). This can be used when arguments of a type other than string are required, and SQLAlchemy’s database connector has no type conversion logic present for that parameter:(第二种方式使用connect_arg参数方式)

 
  db = create_engine('postgresql://scott:tiger@localhost/test', connect_args = {'argument1':17, 'argument2':'bar'}) 
 

The most customizable connection method of all is to pass a creatorargument, which specifies a callable that returns a DBAPI connection:

 
  def connect():
    return psycopg.connect(user='scott', host='localhost')

db = create_engine('postgresql://', creator=connect)