please use sqlalchemy like below:

from sqlalchemy import create_engine,types

dtype_dic = {'column1': types.NVARCHAR(length=200)}

dataframe.to_sql('column1', engine, index=False, if_exists='append', schema='dbo',dtype=dtype_dic)

this code solve my problem with ???? when insert persian character in sql server