Re: [SQL] Recommendation on bytea or blob for binary data like images

2005-09-06 Thread Leon Torres
Thanks for the quick response. We will be using bytea from now on. :-) - Leon Tom Lane wrote: [EMAIL PROTECTED] writes: Hi, I'd like to know what the official recommendation is on which binary datatype to use for common small-binary size use. If bytea will work for you, it's definit

Re: [SQL] Recommendation on bytea or blob for binary data like images

2005-09-02 Thread Tom Lane
[EMAIL PROTECTED] writes: > Hi, I'd like to know what the official recommendation is on which binary > datatype to use for common small-binary size use. If bytea will work for you, it's definitely the thing to use. The only real drawback to bytea is that there's currently no API to read and write

[SQL] Recommendation on bytea or blob for binary data like images

2005-09-02 Thread leon
Hi, I'd like to know what the official recommendation is on which binary datatype to use for common small-binary size use. 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