Re:

Hi,<br /><br />I'm new in using BLOB. How will the insert for storing very large byte strings into a column  of data
typeBlob.<br /><br /><div class="gmail_quote">On Mon, Jul 5, 2010 at 11:42 AM, silly sad <span dir="ltr"><<a
href="mailto:sad@bankir.ru">sad@bankir.ru</a>></span>wrote:<br /><blockquote class="gmail_quote" style="border-left:
1pxsolid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">On 07/05/10 09:57,  wrote:<br /><blockquote
class="gmail_quote"style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi,<br/><br /> How can I store Byte strings into a postgresql database.<br /> Is there any special command to store it.
Howwill be the sql query.<br /></blockquote><br /> there is only '\0' byte incapable to input-output.<br /> so u have
tohave it escaped at all costs _AND NOTHING MORE_.<br /><br /> "escaped" doesn't mean "prefixed with backslash"<br />
("backslashmethod" cause a zero-byte to pass SQL parser an to be actually stored, BUT<br /> the output will be
corrupted,because of this zero-byte will be actually output)<br /><br /> You may use the BYTEA type<br /> (similar to
theTEXT but with different input-output) which effectively escapes zero-byte and a lot of other completely harmless
bytesas well (probably to reach a better overhead)<br /><br /> Or you may introduce a pair of your own escape rules.<br
/><br/> Unfortunately there are no way to influence The Pg Developers to get rid of the nasty god damned CSTRING off
theinput/output operations.<br /><font color="#888888"><br /><br /> -- <br /> Sent via pgsql-sql mailing list (<a
href="mailto:pgsql-sql@postgresql.org"target="_blank">pgsql-sql@postgresql.org</a>)<br /> To make changes to your
subscription:<br/><a href="http://www.postgresql.org/mailpref/pgsql-sql"
target="_blank">http://www.postgresql.org/mailpref/pgsql-sql</a><br/></font></blockquote></div><br /><br clear="all"
/><br/>-- <br />Regards,<br />----------------------------------------------<br />Trinath Somanchi,<br />