PostgreSQL JDBC - recommendation on bytea or blob for binary data like images

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

recommendation on bytea or blob for binary data like images

leon@oss.minimetria.com

2005-09-02, 1:24 pm

Hi, I'd like to know what the official recommendation is on which binary
datatype to use for what situations.

I'm working with the Open For Business (www.ofbiz.org) framework, which by
default maps binary data, such as shipping label images, into OID field
types. In general, the data is far less than a gigabyte in size. Should
this be BYTEA? Is it strongly recommended by the postgresql community to
store things like images in bytea format as of 8.0?

Thanks,

Leon Torres
leon@oss.minimetria.com
Open Source Strategies
http:// opensourcestrategies
.com

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly

Sponsored Links