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

2016-10-05 Thread Mike Bayer
On 10/05/2016 12:38 AM, Jonathan Schultz wrote: 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,

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

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

2016-09-28 Thread Mike Bayer
On 09/28/2016 02:32 AM, jonathan.schu...@gmail.com wrote: 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

[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