该文英文数据库名没问题,但这个库只能调用,无法修改库名
代码如下:
import pandas as pd
import numpy as np
import pymssql
from sqlalchemy import create_engine
coding='utf-8'
engine =create_engine('mssql+pymssql://sa:fuwuqi@172.16.6.170:1433/门禁登记?charset=utf8')
data = pd.read_sql("SELECT * FROM YQ_MUSERS", con=engine)
data
提示错误:UnicodeEncodeError: 'ascii' codec can't encode characters in position 0-3: ordinal not in range(128)
相似问题