<div style="color:#000; background-color:#fff; font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida
Grande,sans-serif;font-size:13px"><div id="yui_3_16_0_1_1453003373099_23692">Pg 9.4+</div><div
id="yui_3_16_0_1_1453003373099_23692"><br/></div><div id="yui_3_16_0_1_1453003373099_23692">Storing binary data using
<aclass="" href="http://www.postgresql.org/docs/8.4/static/datatype-binary.html" id="yui_3_16_0_1_1453003373099_23702"
rel="nofollow">bytea</a>or <a class="" href="http://www.postgresql.org/docs/8.4/static/datatype-character.html"
id="yui_3_16_0_1_1453003373099_23704"rel="nofollow">text</a> data types </div><ul class=""
id="yui_3_16_0_1_1453003373099_23706"><liclass="" id="yui_3_16_0_1_1453003373099_23708"> Pluses <ul class=""
id="yui_3_16_0_1_1453003373099_23710"><liclass="" id="yui_3_16_0_1_1453003373099_23712"> Storing and Accessing entry
utilizesthe same interface when accessing any other data type or record. <li class=""
id="yui_3_16_0_1_1453003373099_23714">No need to track OID of a "large object" you create </ul><li class=""
id="yui_3_16_0_1_1453003373099_23716">Minus <ul class="" dir="ltr" id="yui_3_16_0_1_1453003373099_23718"><li class=""
id="yui_3_16_0_1_1453003373099_23720">bytea and text data type both use <a class=""
href="http://www.postgresql.org/docs/8.4/static/storage-toast.html"id="yui_3_16_0_1_1453003373099_23722"
rel="nofollow">TOAST</a>(details <a class="" href="https://wiki.postgresql.org/wiki/TOAST"
id="yui_3_16_0_1_1453003373099_23724"title="TOAST" title-off="">here</a>) <ul class=""
id="yui_3_16_0_1_1453003373099_23726"><liclass="" id="yui_3_16_0_1_1453003373099_23728"> limited to 1G per entry <li
class=""id="yui_3_16_0_1_1453003373099_23730"> 4 Billion (> 2KB) entries per table <a class=""
href="https://wiki.postgresql.org/wiki/TOAST"id="yui_3_16_0_1_1453003373099_23732" title="TOAST" title-off="">max</a>.
</ul><liclass="" id="yui_3_16_0_1_1453003373099_23734"><b id="yui_3_16_0_1_1453003373099_23878"> Need to escape/encode
binarydata before sending to DB then do the reverse after retrieving the data </b><li class=""
id="yui_3_16_0_1_1453003373099_23736">Memory requirements on the server can be steep even on a small record
set. </ul></ul><divdir="ltr" id="yui_3_16_0_1_1453003373099_23806"><a
href="https://wiki.postgresql.org/wiki/BinaryFilesInDB"
id="yui_3_16_0_1_1453003373099_23804">https://wiki.postgresql.org/wiki/BinaryFilesInDB</a><br/></div><div
id="yui_3_16_0_1_1453003373099_23806"><br/></div><div id="yui_3_16_0_1_1453003373099_23806"><br /></div><div
id="yui_3_16_0_1_1453003373099_23806"><br/></div><div id="yui_3_16_0_1_1453003373099_23806">Do I really <b
id="yui_3_16_0_1_1453003373099_23885"><fontid="yui_3_16_0_1_1453003373099_23963" size="3">Need to escape/encode binary
databefore sending to DB then do the reverse after retrieving the data?</font></b></div><div
id="yui_3_16_0_1_1453003373099_23806"><b><fontsize="3"><br /></font></b></div><div dir="ltr"
id="yui_3_16_0_1_1453003373099_23806"><spanid="yui_3_16_0_1_1453003373099_24014"><font
id="yui_3_16_0_1_1453003373099_24013"size="3">If so, what (<b id="yui_3_16_0_1_1453003373099_24092">Java</b>) codes
shouldI use to achieve this goal (I am using the Java to interface with the DB)?</font></span></div><div dir="ltr"
id="yui_3_16_0_1_1453003373099_23806"><span><fontsize="3"><br /></font></span></div><div dir="ltr"
id="yui_3_16_0_1_1453003373099_23806"><span><fontsize="3"><br /></font></span></div><div dir="ltr"
id="yui_3_16_0_1_1453003373099_23806"><span><fontsize="3"><br /></font></span></div><div dir="ltr"
id="yui_3_16_0_1_1453003373099_23806"><span><fontsize="3">Thanks</font></span></div><div dir="ltr"
id="yui_3_16_0_1_1453003373099_23806"><span><fontsize="3"><br /></font></span></div><div dir="ltr"
id="yui_3_16_0_1_1453003373099_23806"><span><fontsize="3">Eugene</font></span></div></div>
