Thank you Michael,
for that confirmation
I reported the bug to the PHP team, and they issued a patch.
I would also suggest to postgres developpers to simplify their code and go
back to SQL standards :)
That BINARY CURSOR thing should be avoided. With MySQL for instance, a
cursor will read the same way any type of data, binary or text.
----- Original Message -----
From: "Michael Fuhr" <mike@xxxxxxxx>
To: "Eric Mauvière" <e.mauviere@xxxxxxxxxx>
Sent: Sunday, April 16, 2006 6:39 PM
Subject: Re: [PHP] binary cursor returning truncated data
On Wed, Apr 12, 2006 at 04:21:49PM +0200, Eric Mauvire wrote:
i am trying to retrieve binary content of a bytea field (or postgis
geometry field) with a binary cursor with PHP :
$sql="BEGIN;DECLARE mycursor BINARY CURSOR FOR SELECT shape FROM
$layerName; fetch all in mycursor;"
But my shape field shows only two bytes of data.
The PHP source code (ext/pgsql/pgsql.c) doesn't have any calls to
PQfformat or PQbinaryTuples so PHP appears to expect text data.
Looks like you'll have to fetch data in text format and use
Maybe the PHP developers would consider adding support for binary
data (or maybe they already have and rejected the idea; I don't
know). Try asking on a PHP mailing list.
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly