Hello, maybe this ? http://www.postgresql.org/idocs/index.php?datatype-binary.html I really don't know if it is the good type.. However, if you can have a look to mysql, i think it has a BLOB type.. http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#BLO... Never used it though.. Tino Wildenhain wrote:

Hi Terry,

you could either encode the object data base64 or similar or use type byteea (see large objects in postgres).

What do you think you win with saving images in postgres?

Maybe you can go a little bit further and change the oracle storage (ZODB storage) to use postgres.

Regards Tino

--On Montag, 21. Oktober 2002 16:26 +0800 Terry <terry@taipeitimes.com> wrote:

...

Hello,

Does anyone has a example to "Store a image or file(mp3,mpeg) in PostgreSQL". I had tried to search on Google and maillist but no information are really useful or show any idea.

Thanks for any reply or hints

Terry

_______________________________________________

Speaking of the Oracle Storage for ZODB -- does anyone know what the status is on it? I thought I saw that it was last revised in 2000.... although I would be happy if someone told me that I was looking in the wrong spot. (Or maybe that it WAS last touched in 2000, but still does what it needs to do) My day job has standardized on Oracle as a data repository for all current development... so if I can get Zope to pump into an Oracle database that greatly increases my chances of having Zope accepted. As for a postgres port, that would be cool too... And about storing binary data, the common consensus on the postgresql list seems to say use a byte array. On Mon, 2002-10-21 at 04:20, Tino Wildenhain wrote:

Hi Terry,

you could either encode the object data base64 or similar or use type byteea (see large objects in postgres).

What do you think you win with saving images in postgres?

Maybe you can go a little bit further and change the oracle storage (ZODB storage) to use postgres.

Regards Tino

--On Montag, 21. Oktober 2002 16:26 +0800 Terry <terry@taipeitimes.com> wrote:

...

Hello,

Does anyone has a example to "Store a image or file(mp3,mpeg) in PostgreSQL". I had tried to search on Google and maillist but no information are really useful or show any idea.

Thanks for any reply or hints

Terry

_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )

_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )