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) buffer = image.getvalue() param = dict(picture=bytearray(buffer) thanks a lot for your consideration :) alex there was no need to use pyodbc.Binary, since it has the very same effect. On 06/12/2013 06:36 PM, Michael Bayer wrote: > 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 <alexbodn.gro...@gmail.com> wrote: > >> >> 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 tablename(img) values(:img)" >> DBSession.execute(sql, dict(img=bytearray(data)) >> >> data is not empty, but it just retrieves as bytearray(b'') >> could you advice me? >> >> many thanks in advance, >> alex >> >> -- >> You received this message because you are subscribed to the Google Groups >> "sqlalchemy" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to sqlalchemy+unsubscr...@googlegroups.com. >> To post to this group, send email to sqlalchemy@googlegroups.com. >> Visit this group at http://groups.google.com/group/sqlalchemy?hl=en. >> For more options, visit https://groups.google.com/groups/opt_out. >> >> > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy?hl=en. For more options, visit https://groups.google.com/groups/opt_out.