[Zope] storing blob data in SQLServer using ZSQL

[rawsystems at gmail.com]

Years ago i posted something on this list (gosh, two years ago and i'm still 
a newbie :)  )

http://mail.zope.org/pipermail/zope-db/2004-July/003356.html

Google is your friend.

hth

bobb

----- Original Message ----- 
From: "Jonathan" <dev101 at magma.ca>
To: "Satchidanand Haridas" <sharidas at zeomega.com>
Cc: <zope at zope.org>
Sent: Wednesday, June 28, 2006 4:50 PM
Subject: Re: [Zope] storing blob data in SQLServer using ZSQL


>
> ----- Original Message ----- 
> From: "Dieter Maurer" <dieter at handshake.de>
> To: "Satchidanand Haridas" <sharidas at zeomega.com>
> Cc: <zope at zope.org>
> Sent: Wednesday, June 28, 2006 4:10 PM
> Subject: Re: [Zope] storing blob data in SQLServer using ZSQL
>
>
>> Satchidanand Haridas wrote at 2006-6-27 19:37 -0500:
>>>How can I save blob data in SQLServer using ZSQLs? I'm using mxODBC. I
>>>have a ZSQL that looks something like this:
>>>
>>>> update
>>>>     table_name
>>>> set
>>>>     blob_data = <dtml-sqlvar "i_blob_data" type="nb">
>>>> where
>>>>     conditions....
>>>But I get the following error when I run the above ZSQL:
>>>
>>>> ProgrammingError: ('07002', 0, '[Microsoft][ODBC SQL Server
>>>> Driver]COUNT field incorrect or syntax error', 6108)
>>
>> You cannot use "ZSQL" to put binary (blob) data into
>> the database. You can have some chance when you use
>> base64 encoding -- provided, your data is not too large.
>
> An easy work-around would be to store your blob in the zodb and then store 
> the path/id of the zodb object in your SQL db.
>
>
> Jonathan
>
>
> _______________________________________________
> Zope maillist  -  Zope at zope.org
> http://mail.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce
> http://mail.zope.org/mailman/listinfo/zope-dev )