Re: Displaying image from php script displays string - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: Displaying image from php script displays string
Date
Msg-id 504F618C.8010709@iol.ie
Whole thread Raw
In response to Displaying image from php script displays string  (Alexander Reichstadt <lxr@me.com>)
List pgsql-general
On 11/09/2012 14:24, Alexander Reichstadt wrote:
>
>
> What am I doing wrong?
>

What version of PG are you using? The default output format of bytea
changed from "escape" to "hex" a version or two ago - try changing it to
"escape" and see if that makes a difference:

  ALTER DATABASE xxxxx SET bytea_output='escape';

BTW, it's a REALLY bad idea to build literal SQL queries from input
values, as you're doing - you should use parameters and
pg_query_params() instead.

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie


pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Displaying image from php script displays string
Next
From: John R Pierce
Date:
Subject: AIX and ipv6