Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group