Postgres Pro
Downloads
Home   >   mailing lists

Re: Store base64 in database. Use bytea or text? - Mailing list pgsql-general

From Jasen Betts
Subject Re: Store base64 in database. Use bytea or text?
Date
Msg-id ihvj0q$9q0$4@reversiblemaps.ath.cx
Whole thread Raw
In response to Store base64 in database. Use bytea or text?  (Andre Lopes <lopes80andre@gmail.com>)
List pgsql-general
Tree view 
On 2011-01-26, Bill Moran <wmoran@potentialtech.com> wrote:

> DO NOT use parametrized queries with PHP and bytea (I hate to say that,
> because parametrized fields are usually a very good idea).  PHP has a
> bug that mangles bytea data when pushed through parametrized fields.
>
> PHP bug #35800

OOTOH pg_insert() and pg_update() work well with bytea data

--
⚂⚃ 100% natural

pgsql-general by date:

Previous
From: Jasen Betts
Date:
Subject: Re: Separating the ro directory of the DB engine itself from the rw data areas . . .
Next
From: Andrew Sullivan
Date:
Subject: Re: Re: Separating the ro directory of the DB engine itself from the rw data areas . . .