在Pyramid Web应用中，使用pymssql尝试通过存储过程将二进制数据插入MSSQL数据库遇到问题。数据库列类型为VARBINARY(MAX)，错误提示不允许从varchar隐式转换为varbinary(max)。解决方案可能需要显式转换varchar数据。
I'm trying to insert binary data into an MSSQL database using stored procedures from within an pyramid web application using pymssql.
The MSSQL datatype for the respective column is varbinary(max).
My question is: What does the varbinary datatype of the MSSQL database expect me to do with the binary file before inserting it?
Here's what I've been trying:
with open(tmp_file, 'rb') as content_file:
filecontent = content_file.read()
... and then pass the value of filecontent to the stored procedure.
tmp_file in this case is a valid path to a .png file.
The MSSQL db answers with the following error:
*** DatabaseError: (257, 'Implicit conversion from data type varchar to varbinary(max) is not
allowed. Use the CONVERT function to run this query.DB-Lib error message 257, severity 16:\nGeneral
最低0.47元/天 解锁文章
扫一扫
537
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
