[Zope] mySQL image addition

[Alexander Staubo]

If it's of any help: I've stored images in MS SQL (not MySQL) servers,
and this is somewhat painful, because you need to convert the binary
data into hexadecimal values, thus:

	insert into foo (myimage) values (0x01020304[...])

I don't know MySQL does BLOb inserts. However, I think it's reasonable
that you cannot simply enter a literal string; or? How does Zope handle
it?

(Btw, I wrote a C extension for Python that performs the hex conversion
(because it took literally hours if done in pure Python), and one
problem that bugged me for some time was that SWIG doesn't generate
wrappers that can take strings containing null bytes; the Python API was
transforming my strings into some kind of weird 7-bit-ish format. The
solution was to patch SWIG's wrapper code manually (Jim, do know if SWIG
can be told to do this?) to parse the string argument differently.)

--
Alexander Staubo             http://www.mop.no/~alex/
"What the hell, he thought, you're only young once, and threw
himself out of the window. That would at least keep the element of
surprise on his side."
--Douglas Adams, _The Hitchhiker's Guide to the Galaxy_

>-----Original Message-----
>From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of
>Martijn Pieters
>Sent: 6. juli 1999 01:03
>To: Phil Grove; zope@zope.org
>Subject: Re: [Zope] mySQL image addition
>
>
>At 14:59 05/07/99 , Phil Grove wrote:
>>hi all,
>>
>>has anyone used mySQL to hold a number of images uploaded
>using Zope? If so
>>how can it be done, i have tried using the normal INSERT
>statments into a
>>BLOB field in the database but it only seems to insert a
>strange instances
>>string??
>>
>>Any ideas would be appreciated.
>>
>>P.
>
>No experience using images stored in a DB, but the 'strange instances
>string' sounds familiar enough. Can we see your code?
>
>--
>Martijn Pieters, Web Developer
>| Antraciet http://www.antraciet.nl
>| Tel: +31-35-7502100 Fax: +31-35-7502111
>| mailto:mj@antraciet.nl http://www.antraciet.nl/~mj
>| PGP:
http://wwwkeys.nl.pgp.net:11371/pks/lookup?op=get&search=0xA8A32149
------------------------------------------

_______________________________________________
Zope maillist  -  Zope@zope.org
http://www.zope.org/mailman/listinfo/zope

(For developer-specific issues, use the companion list,
zope-dev@zope.org - http://www.zope.org/mailman/listinfo/zope-dev )