From: | "Ben-Nes Michael" <miki(at)canaan(dot)co(dot)il> |
---|---|
To: | "Alex Pilosov" <alex(at)pilosoft(dot)com> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: store in bytea |
Date: | 2001-08-26 09:27:31 |
Message-ID: | 00b601c12e11$54f441a0$aa5796d4@canaan.co.il |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 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 select for output.
> >
> > Does any one here save his website images on DB and retrive them out on
his
> > web page ?
> >
> > > "Ben-Nes Michael" <miki(at)canaan(dot)co(dot)il> 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 characters.
> > >
> > > Use BYTEA if you want to store arbitrary byte sequences --- that's
what
> > > it's for.
> > >
> > > regards, tom lane
> > >
--------------------------
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
http://sites.canaan.co.il
--------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Mark kirkwood | 2001-08-26 11:17:31 | Re: problems on solaris 7 |
Previous Message | Michael Meskes | 2001-08-26 07:34:38 | Re: embedded SQL cursos declare fails |