sqlalchemy

关注

原创最新推荐文章于 2026-05-17 07:24:20 发布 234 阅读 AI 写同款· GEO 优化 ›

【SQLAlchemy 】create_engine 连sql server 中文乱码解决方案写给老是卡在读sql server中文数据乱码的自己。前情提要数据库里只要存varchar字段就自动 Chinese_PRC_CI_AS，用SQLAlchemy怎么换charset参数都不好使。 conn = create_engine('mssql+pymssql://xx:xxxx.@localhost:post/db_name?charset=utf8').connect() conn = create_engine('mssql+pymssql://xx:xxxx.@localhost:pos 阅读详情

# sqlite 创建数据库连接
engine = create_engine('sqlite:///database.db', echo=False)

# sqlite 创建内存数据库
engine = create_engine('sqlite://')
engine = create_engine('sqlite:///:memory:', echo=True)

# PostgreSQL 创建数据库连接
engine = create_engine('postgresql://scott:tiger@localhost/mydatabase')                # default
engine = create_engine('postgresql+psycopg2://scott:tiger@localhost/mydatabase')       # psycopg2
engine = create_engine('postgresql+pg8000://scott:tiger@localhost/mydatabase')         # pg8000

# MySQL 创建数据库连接
engine = create_engine('mysql://scott:tiger@localhost/foo')                  # default
engine = create_engine('mysql+mysqldb://scott:tiger@localhost/foo')          # mysql-python
engine = create_engine('mysql+mysqlconnector://scott:tiger@localhost/foo')   # MySQL-connector-python
engine = create_engine('mysql+oursql://scott:tiger@localhost/foo')           # OurSQL

# Oracle 创建数据库连接
engine = create_engine('oracle://scott:tiger@127.0.0.1:1521/sidname')
engine = create_engine('oracle+cx_oracle://scott:tiger@tnsname')

# MSSQL 创建数据库连接
engine = create_engine('mssql+pyodbc://scott:tiger@mydsn')                   # pyodbc
engine = create_engine('mssql+pymssql://scott:tiger@hostname:port/dbname')   # pymssql