Re: binary cursor returning truncated data

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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.

Best regards,

Eric Mauvière

----- Original Message ----- From: "Michael Fuhr" <mike@xxxxxxxx>
To: "Eric Mauvière" <e.mauviere@xxxxxxxxxx>
Cc: <pgsql-php@xxxxxxxxxxxxxx>
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.

Michael Fuhr

---------------------------(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

[Index of Archives]     [Postgresql General]     [Postgresql Admin]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Backpacking]     [Postgresql Jobs]

  Powered by Linux