[sqlalchemy] image field in mssql

2013-06-12 Thread alex bodnaru
hello friends, i'm happily using sa, both with a declarative/elixir orm, and directly through DBSession.execute(text statement). there is an issue that works great with orm, but i don't khown how to achieve in direct execution: image fields. i'm inserting the data as: sql = insert

Re: [sqlalchemy] image field in mssql

2013-06-12 Thread Michael Bayer
blobs are problematic, and this is often highly dependent on DBAPI version and platform. So can you send along details: 1. python version 2. operating system 3. SQLAlchemy version 4. DBAPI in use, version I can give it a test on this end. On Jun 12, 2013, at 6:00 AM, alex bodnaru

Re: [sqlalchemy] image field in mssql

2013-06-12 Thread alex bodnaru
hello michael, as usually, you were faster than me to answer. after reviewing my surrounding code to fix additional bugs there, i've just found the answer: a bytearray is needed as sql param. i've built the buffer from an image with BytesIO. im = Images.new() image = BytesIO() im.save(image)