Re: [sqlalchemy] Inserting VARBINARY(MAX) columns with MSSQL/SQLAlchemy

2016-10-04 Thread Jonathan Schultz
Many thanks for the prompt reply. if you are getting that error on INSERT it sounds like there are driver > issues involved (e.g. pymssql, pyodbc). For an INSERT you should not > get that error; using the VARBINARY SQLAlchemy type, SQLAlchemy calls > upon a construct provided by your DBAPI

[sqlalchemy] Inserting VARBINARY(MAX) columns with MSSQL/SQLAlchemy

2016-09-28 Thread jonathan . schultz
Usual apologies for newbie question... I'm trying to use SQLAlchemy to insert data into a MSSQL DB with columns of type VARBINARY(MAX). The only way I could find to avoid the error message > Implicit conversion from data type varchar to varbinary(max) is not > allowed. Use the CONVERT