Re: [GENERAL] store in bytea

2001-08-26 Thread Ben-Nes Michael
Im using PHP4.6 > What are you using to develop? If perl, DBD::Pg will escape/unescape bytea > data after 0.98 version. (Unescaping is automatic, to escape, you need to > do bind(.., SQL_BINARY)). > > -alex > > On Fri, 24 Aug 2001, Ben-Nes Michael wrote: > > > But Ill have to add double slashes a

Re: [GENERAL] store in bytea

2001-08-24 Thread Ben-Nes Michael
But Ill have to add double slashes and even more importent I will have to unescape every binary data going out of the server, which mean in one of my aplication all the Images. Wont this action be much more heavey then the way I used untill now with MySQL (blob) ? addslash on insert and ordinary

Re: [GENERAL] store in bytea

2001-08-24 Thread Tom Lane
"Ben-Nes Michael" <[EMAIL PROTECTED]> writes: > On the theoretical issue, can I use TEXT field to store binary ? TEXT will not handle null (zero) bytes. If you are using a multibyte character set, it will likely also do the wrong thing with byte sequences that are illegal or incomplete multibyte

Re: [GENERAL] store in bytea

2001-08-23 Thread Ben-Nes Michael
PROTECTED]> Sent: Thursday, August 23, 2001 10:18 PM Subject: Re: [GENERAL] store in bytea > > Hi > > > > Im using php to upload Binary data into bytea field. > > The problem is that when I query what I uploaded I discover that it hold > > only 13 characters and