Yes, if I use your function it works. NP.
The problem I have now, is what do I have to do special to get the data
back out in proper format? Or does it come out in useable form?
-Bob
ccrider@whiterose.net
Systems Administrator for whiterose.net
http://www.whiterose.net
On Sun, 24 Feb 2002, Thomas T. Thai wrote:
> On Sun, 24 Feb 2002, Robert Myers wrote:
>
> > I did this with the CVS version of PHP, v 4.2.0 dev.
> >
> > I downloaded it for the function pg_escape_bytea, still no go, I can't get
> > the data into the field.
>
> did you try as i said below? i've tested it on php 4.0.6 - 4.1.0. i've not
> used pg_escape_bytea so i can't comment on it.
>
> > > > I'm having a problem with the bytea datatype. I'm trying to store image
> > > > data inside the field in a table, and php seems to only be sending a small
> > > > portion of the image into the database.
> [...]
> > > to use bytea with php, encode the image data with escByteA() below before
> > > storing it in your db. then when you retrieve the data, use php's
> > > stripcslashes(). i've tested this on various image data and they all work
> > > just fine.
> > >
> > > function escByteA($binData) {
> > > /**
> > > * \134 = 92 = backslash, \000 = 00 = NULL, \047 = 39 = Single Quote
> > > *
> > > * str_replace() replaces the searches array in order.
> > > * Therefore, we must
> > > * process the 'backslash' character first. If we process it last, it'll
> > > * replace all the escaped backslashes from the other searches that came
> > > * before. tomATminnesota.com
> > > */
> > > $search = array(chr(92), chr(0), chr(39));
> > > $replace = array('\\\134', '\\\000', '\\\047');
> > > $binData = str_replace($search, $replace, $binData);
> > > return $binData;
> > > }
>
>
>