Re: Store base64 in database. Use bytea or text?

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Store base64 in database. Use bytea or text?
Date: 2011-01-28 23:20:58
Message-ID: ihvj0q$9q0$4@reversiblemaps.ath.cx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2011-01-26, Bill Moran <wmoran(at)potentialtech(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2011-01-29 00:37:46 Re: Re: Separating the ro directory of the DB engine itself from the rw data areas . . .
Previous Message Jasen Betts 2011-01-28 22:52:26 Re: Separating the ro directory of the DB engine itself from the rw data areas . . .